Hi All,
I have a worksheet called "Historical" which has data in a range A2:G1256. This range may not all have data every time.
I wish to copy the last 62 rows of whatever rows have been populated. Then the data needs to be copied and pasted into another worksheet called "Charts" in the range (AE3:AK65)
Would prefer a formula instead of a macro if it can be done.
Thanks in advanced.
Bookmarks