Copy down Formulas from top line of range to last

[Ralphie2396]

Hi,

I have a range of data set and when I insert a new line this range then includes the line. I then would like to use a macro to say once that line has been inserted copy down the formula from the first row of the range all the way down the range to the last row within the range so that the formula all work correctly as if the cells had been copied down via dragging them.

Any help would be great

Many thanks

[leelnich]

Hi, Ralphie2396, welcome to Excel Forum! A small sample workbook would help us to solve your problem quickly and accurately. Please remove any personal or proprietary information. Try to use your original layout so our solutions fit your workbook, and highlight the formula cells you need copied.

To attach a workbook:
Click Edit Post (or just start a new reply.)
Click Go Advanced
Scroll down to Manage Attachments and click.
Now click Browse, find your file, then click Upload. Simple!

[jolivanes]

Change the 1 in "End(xlUp).Row, 1))" to the number of columns in the range

Please Login or Register  to view this content.

[Ralphie2396]

Hi, Ralphie2396, welcome to Excel Forum! A small sample workbook would help us to solve your problem quickly and accurately. Please remove any personal or proprietary information. Try to use your original layout so our solutions fit your workbook, and highlight the formula cells you need copied.

To attach a workbook:
Click Edit Post (or just start a new reply.)
Click Go Advanced
Scroll down to Manage Attachments and click.
Now click Browse, find your file, then click Upload. Simple!

Hi,
See the attached spreadsheet where a new line has been inserted therefore the range (Test) is cells E7:S9, I would like to copy the formulas down from Row 7 within this range down to the bottom of this range with a macro. Assuming this range will increase everytime a new line is inserted at the bottom of the range. I currently have a macro to insert the line above the line with Total in which works fine i just need the step above after.

Kind regards.

[jolivanes]

Please Login or Register  to view this content.