Dataframe
New Member
- Joined
- Dec 8, 2022
- Messages
- 17
- Office Version
- 2016
- Platform
- Windows
Hi everyone. Is there VBA code to take you to the 2nd Previously Active Sheet ?
I have Sheets 1 to 12, a Raw Data sheet, and a Transfer sheet. From one of the sheets 1-12 (continually varying) I run a macro that processes and moves selected data from the Raw Data sheet to the Transfer sheet.
After that is done, I need to return to whichever of the Sheets 1 to 12 that I originally came from.
So, to recap ...
1. Start in one of the sheets 1-12. Running a Macro there takes me to ...
2. Raw Data sheet. The Macro processes data and transfers it to ...
3. Transfer sheet. I then wish to return to whichever sheet I started in.
Can this be done ?
I have Sheets 1 to 12, a Raw Data sheet, and a Transfer sheet. From one of the sheets 1-12 (continually varying) I run a macro that processes and moves selected data from the Raw Data sheet to the Transfer sheet.
After that is done, I need to return to whichever of the Sheets 1 to 12 that I originally came from.
So, to recap ...
1. Start in one of the sheets 1-12. Running a Macro there takes me to ...
2. Raw Data sheet. The Macro processes data and transfers it to ...
3. Transfer sheet. I then wish to return to whichever sheet I started in.
Can this be done ?