Hello All,
Im looking for a way to import variable data from different columns in two different open workbooks to a master file. In the attached workbook I've given an example of the data in two different books on the Data1 and Data2 worksheets, and what the finished product should look like on the FinishedData sheet.
The code I'm working with is this:
and this:Please Login or Register to view this content.
There are two different buttons to call each macro. Of course, the current code will copy ALL of the data, and I need it to only grab a specific set of columns, preferably without using the clipboard. In the actual master file, "Test" is the worksheet name the data is copied to.Please Login or Register to view this content.
Any help would be greatly appreciated, Thanks!
Bookmarks