Hello,
I need to copy cells from one workbook and paste them into a different workbook. I would prefer for the destination workbook to not have to be open when the VBA is running. If that is not possible, maybe I could included an 'open Home workbook' code in the VBA?
Attached are two sample workbooks that I am using. Home is where the information is stored and Destination is where I'd like to paste the information. The Destination file will have the pasted information organized in a row/column format.
Home has roughly 250 tabs in the actual workbook that are titled with the Company Name.
Thank You so much in advance.
Rob
Bookmarks