I'm trying to create a backup macro that copies data from 2 different sheets in my program onto one new workbook. Then be able to later load the saved data back in. I'm working on the saving part now and I'm stuck getting the data out. Im using
workRng2 isnt copying or pasting onto tab 2 of the new workbook. Any ideas? I dont want to have to save the data on 2 seperate workbooks if possible.Please Login or Register to view this content.
Bookmarks