I have about 300 lines of the following macro:
It copies from 6 different tables data to sheet1 in the same workbook.Please Login or Register to view this content.
Now I would like to change it so that it will copy the data to another workbook I have open. The name of the new workbook is “Andmed” (file name). Sheet name is still sheet1. The workbook name of the file where I will copy from will change as I need to run this macro about 200 times. I will probably run the macro from this workbook but store it in “Andmed” workbook.
Also before copying the data it should insert a new line to workbook “Andmed” sheet1 line2. To greate a space for the data as not to overwrite previous data.
All help will be greatly appreciated,
Bookmarks