Data between two workbooks

lordriel

Board Regular
Joined
Nov 1, 2005
Messages
61
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
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

RalphA

Well-known Member
Joined
May 14, 2003
Messages
3,829
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.
 

Forum statistics

Threads
1,137,366
Messages
5,681,072
Members
419,950
Latest member
BeckiJae

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top