Every week a new report comes out that I save as a text file and refresh in my Excel workbook, this is in sheet 1. As each week comes out, I start a new row and I copy and paste certain data from that report on sheet 1 to sheet 2. I was thinking that there must be a way to link the cells that have the data I use in sheet 1 to my historical sheet 2. The problem is, if I link the cells between sheet 1 and 2, the data from previous weeks will change as well because the data I pull is in the same cells each time I refresh the page. I want to find a way to add a new row referencing the corresponding cells each week and keeping the previous row from the previous from changing. I am not familiar with VBA at all, but may have to try and dive in. Any suggestions?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Adding a new row when refreshing text connection
- Thread starter C_merr
- Start date
Similar threads
- Question
