Morning all,
What VBA code do I require to copy the formulas in cells D4 and E4 down to match the same row as the last date in the pivot table running adjacent to it, i.e. down to row 116? The pivot table will regularly change size so ideally I need something to recognise the size of the pivot table and copy down accordingly.
Example attached.
Thanks in advance,
Snook
Bookmarks