Fill in formulas for rows with data only.

R

rory_r

Firstly thanks to all the help in this forum.
I have a spreadsheet with 1 row of 14 columns of data and 6 columns of
formulas to perform various calcs on the first 14 columns.
I copy paste data into the rows below and drag the 6 columns of data down to
the end of the data which some days are 200 rows sometimes 2000. I tryed
dragging the formulas first and saving the form before pasting but it slows
the calcs down on light days too.
I have a macro that pastes and configures the columns for conditional
formatting etc.
I'd like to have a macro that then drags the last 6 columns down to the last
row with data on it only.
Any ideas?
Again thanks in advance.
Rory
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top