Hello,
I am trying to copy-paste data from one sheet in one workbook to a tab in a different sheet by using a macro, but am having trouble. Essentially what I am trying to do is:
*I have a "Master.xlsm" workbook, with a tab called "DATA"
*I have several additional workbooks "Version1.xlsx" "Version2.xlsx" "Version3.xlsx"
*I have tabs in all of the sheets named "DATA"
*What I want to do, is have a macro in "Master.xlsm" that, when run, copies the entire "DATA" sheet from that book, and pastes into the already existing "DATA" tabs in the other three workbooks.
I am having troubles doing this, and cannot find an already written macro that I can manipulate. I would be very appreciate of any help!!
Thanks so much,
Molly
Bookmarks