Hi,
No one likes change! So this spreadsheet has been built to display data....
I'm trying to make it user friendly to save the data into a list. Before it is reset.
There are 24 tables on the sheet, all similar setup - only include top 8 in s/sheet.
I would like to capture all the data as shown in "Past data" sheet - I didn't put it all there. Each time a table is reset the data would be written to the end of this sheet - should hold a few years data!
What I was hoping was to start a macro when in the yellow cell and it would transfer data.
I tried recording a macro but too messy, then tried VB code (from this site) but didn't quite work.
Any thoughts?
I thought I could alter this VBA given in this post:
http://www.excelforum.com/excel-prog...to-a-list.html
But I got too confused!
Thanks!
Bookmarks