Stuck on code to copy data from one sheet to another

[epactheactor]

Hello!

I've used VBA when needed, so I in no way an expert but can get it to do what is needed, when needed.

My issue is I am trying to create a macro or VBA code that would copy specific data from one workbook to another. The issue is that each workbooks have different names.

So the example would be, Workbook A would copy data into workbook B.
Workbook C would copy data into workbook D,
etc, etc for about 80 pairs.

If the names of the two workbooks were constant, I would be able to do it no problem.

Does anyone have any ideas of how I could possibly do such a thing?

[davsth]

You need to create a lookup table with a column for each worksheet, then depending on the worksheet that is open

Please Login or Register  to view this content.

will give you the current workbookname, you look this up against the table to find the name to save it to.

[AlphaFrog]

Does the code open the workbooks or does the user manually open the workbooks?

Are only two workbooks open at one time or all workbooks open at once?


You can reference workbooks by index number (the order they were opened) as seen in the list in the Window menu

Please Login or Register  to view this content.

Or you can loop through all opened workbooks and "find" the desired workbook based on a cell value or tab name or anything unique about it.

[epactheactor]

Thank you, your help steered me in the right direction.

Sadly, since all the files had different names and could not all be opened at one time (over 400 of them), I had to create a macro which found each workbook via the path, then copied and pasted the information over.