Nanogirl21
Active Member
- Joined
- Nov 19, 2013
- Messages
- 330
- Office Version
- 365
- Platform
- Windows
Hi,
Happy New Year!
How can I import and replace data from another workbook into the active worksheet?
Ideally, I’d like a prompt to select the import file since it will be different every time I use the VBA. The sheet name in the import file will always be named Default.
The import data would be pasted in the active sheet of the workbook starting in row 2 (row 1 is headers). All “old” data should be removed.
A prompt confirming successful import would be helpful too.
Thank you for any help.
Happy New Year!
How can I import and replace data from another workbook into the active worksheet?
Ideally, I’d like a prompt to select the import file since it will be different every time I use the VBA. The sheet name in the import file will always be named Default.
The import data would be pasted in the active sheet of the workbook starting in row 2 (row 1 is headers). All “old” data should be removed.
A prompt confirming successful import would be helpful too.
Thank you for any help.