ExcelAtEverything
Active Member
- Joined
- Jan 30, 2021
- Messages
- 351
- Office Version
- 2019
- Platform
- Windows
Hello smart VB Excel peeps!
Let's say that my active sheet is called "Sheet1", and I have an entire sheet in another workbook which I need to import into my active sheet ("Sheet1"). The sheet in the other workbook right now is titled "2021 Budget - Sales Ony", but that "2021" may change next year, and it could even change completely to something like "2022 Plan". There will always be a year in the title, but the rest may or may not change.
Is there a macro I can attach to a button in my "Sheet1", which will copy the entire page from the other sheet, and paste into "Sheet1" regardess of the name (maybe if it's the only other sheet open)?It sounds like a stupid question to me, because with a changing name how would Excel know where to copy from. But figured I'd ask before trying to rethink a different way.
Thanks!
Let's say that my active sheet is called "Sheet1", and I have an entire sheet in another workbook which I need to import into my active sheet ("Sheet1"). The sheet in the other workbook right now is titled "2021 Budget - Sales Ony", but that "2021" may change next year, and it could even change completely to something like "2022 Plan". There will always be a year in the title, but the rest may or may not change.
Is there a macro I can attach to a button in my "Sheet1", which will copy the entire page from the other sheet, and paste into "Sheet1" regardess of the name (maybe if it's the only other sheet open)?It sounds like a stupid question to me, because with a changing name how would Excel know where to copy from. But figured I'd ask before trying to rethink a different way.
Thanks!