Hello LazyStudent,
The following VBA code may do the task for you:-
It is a Worksheet_Change event and needs to be placed into the Summary sheet module. To implement the code:-
- Right click on the Summary sheet tab.
- Select "View Code" from the menu that appears.
- In the big white field that then appears, paste the above code.
I've attached your file with the code implemented for your perusal.
In the Summary sheet, I've added a drop down in A2 with the two sheet names (001 and 002). Select one or the other from the drop down and you'll see row2 populate with the data that you wish to see there.
I hope that this helps.
Cheerio,
vcoolio.
Bookmarks