I've attached a sample worksheet so show an example of what I want to do.
When I refresh the data, row 5 of sheet 1 updates to the next date and next higher number. After refreshed, Excel automatically copies the entire row and pastes it into sheet 2 on the correct corresponding row so I can create a history of data from each day.
Is this possible?
Thanks!
Bookmarks