Copy and Paste from One Workbook to Another

[rbell22]

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

[Richard Buttrey]

You will need to open the workbook to be able to do that.

I generally Dim a variable for it and also one for the current workbook so that you can jump back and forth if necessary

e.g.

Please Login or Register  to view this content.