Hi.
I have some data in columns A to D and formulas in cells E to G.
At the moment my macro just copies down the formula from E to G to about 500 so I know I capture all the rows in A to D. not ideal.
The problem is when I refresh my data in A to D new rows are added but the formula does not copy down all the way automatically so that's why i set up a macro to cover this. However it seems pointless and a waste of disk space to copy down so much when its not need.
I have about 15 workbooks with about 8 sheets in each that need updating like this so all the excess formulas takes up a bit of disk space.
So basically i want my macro to only copy down the formula to only rows where there is data. Like when you do 'CTRL+down arrow' but only that doesn't record properly in a macro.
Hope this makes sense
Bookmarks