Hello,

I would like to create a macro that will copy formulas from the top of each column down to a row number that I specify (as the number of rows are always changing).

I currently have to manually select the top of each column with a formula in (not all adjacent to one another) and copy & paste it down to the end of the worksheet. There are around 21 columns that I have to do this for whenever new data is pasted into the spreadsheet and overrides the formulas.

I would like to just click a button named 'copy formulas' and any column with a formula will be copy & pasted right down to the end of the data.

Is this possible? Any help will be greatly appreciated.

Thanks,

Kelly

I would like to create a macro that will copy formulas from the top of each column down to a row number that I specify (as the number of rows are always changing).

I currently have to manually select the top of each column with a formula in (not all adjacent to one another) and copy & paste it down to the end of the worksheet. There are around 21 columns that I have to do this for whenever new data is pasted into the spreadsheet and overrides the formulas.

I would like to just click a button named 'copy formulas' and any column with a formula will be copy & pasted right down to the end of the data.

Is this possible? Any help will be greatly appreciated.

Thanks,

Kelly

## Comment