Hi,
I am trying to copy a range of cells down that has formulas in them but when recording the macro is keeps the last row pasted to. I need to make it dynamic.
Data in columns B to H could be 10 rows long or 20 or 50. The formulas Cells I2 to O2 need to be copied to the last row used in column B and then copied ready for use elsewhere.
The crucial bit is needs to pasting of I2 to O2 to be down to last column used in B.
I have attached the test file.
Hope someone can help. Thanks in advance.
Bookmarks