Hello Excel Gurus!
I have absolutly no idea how to do this, but have over the years found that pretty much anything is possible in excel, so lets see.
I have a workbook which has one sheet "Raw Data" where I will cut and past blocks of data of various numbers of rows.
Another sheet "level one calcs" conducts various calculations on the raw data.
I was wondering if there would be any way to create a macro which would copy down (autofill) the last row of my my calculation page for the exact number of rows I added into the raw data.
The goal here would be so that I dont have to highlight and copy down the formulas on the calc sheet each time I add in new data.