I've been using this code:
from the magnificent Mr deBruin and it does almost exactly what I need.![]()
Please Login or Register to view this content.
The only problem I have with it is that it automatically creates a brand new workbook to merge the data to. Is there anyway to adjust the code above so that it merges the data to a specific page in the same workbook as the code? Say, sheet 2?
Thanks for your help.
Edit: Actually, don't worry about it, I sorted it.
Note to self: Play about with code before asking questions.
Bookmarks