Data between two workbooks

[lordriel]

Hopefully someone can help...

I want to copy data from one workbook to another, automated via userform.

I have the userform...and both workbooks open...but I can't figure out how to reference the source worksheet and destination worksheet in VBA.

I know this is probably simplistic and I'm just in a state of overlook...

Any help is greatly appreciated!

- lr

 

[RalphA]

I know too little of VBA to help you directly. But, try this: click on Tools, Macro, Record macro, then continue by doing a copy from the source worksheet, and a Paste to the destination worksheet, then do a Tools, Macro, Stop recording. Now, do a Tools, Macro, Macros, click on the macro you just created and select Edit. You will now see the VBA code Excel produced, and you should now be able to see how to address the source and destination worksheets.
Let us know if this helped yousolve your problem.