Re: AutoFill Down Rows Based On Another Columns Last Cell
Thanks for that - but it dosnt quite seem to do what I want, but it definatly got me a lot closer! let me try to be a bit more specific.
On sheet "raw data" I will be pasting the additional rows (each month as new data comes in).
On sheet "Level 1 Calculations" I have formulas in each of the colums starting from row A6 (through AC6). Many of these formulas are just to copy data in from raw data, but others are more complex.
I want to copy down these formulas for the number of rows that will exist (including the additions) on Raw data. Raw data sheet also starts its data at A6 but only goes to S6.
Example - before I add anything both Raw Data and Level 1 Calculations have rows A6-A2,000 filled with data. I add in the monthly data into Raw Data giving it data in rows A6-A2065. I want to copy down the formulas in each of the columns far enough to include the new data (from A6 to A2065).
Thanks!!! I hope soon Ill be on the other side of the asking/answering side of this forum.