Macro that will copy data from one workbook and paste it into another

[Orlic]

Hello, I need a macro that will copy data from one workbook and paste it into another. The purpose of this macro is to copy data from a user-friendly sheet to an intermediate pivot table friendly sheet, so it can then be processed into a pivot table.

Also, it would be great if this could be made into a button on the first sheet mentioned above (the user-friendly one that compiles into the pivot table list), so that when it is pressed the macro activates.

I'm new to macros, so please tolerate any questions I may ask. Thanks.

[scadaman29325]

I'm new too but have been using macros for a while, but not doing much VB until recently.

Not knowing your expertise (or lack thereof (as in my case)) I would suggest you go to the Tools/Macros/RecordMacro menu and record your proceedure manually.

Then open the script and edit as needed asking questions as you go.


Below is some cmds that I use a lot, NOT the whole script.

Assuming your source wkbk is already open,

The first cmd opens the destination Workbook

Then re-focus on the source wkbk, picks the wksh and the range to copy

Then will re-focus on the destination wkbk and cell, then paste as values (incase they are formulas).

And finally save/close the destination, leaving the source open.

Please Login or Register  to view this content.

I'm SURE these gurus will test that apart with all the fancy stuff and error traps...

Hope this helps, Phil

[Orlic]

Sorry for the late reply. Thanks man it worked like a charm.