Create a macro to copy data from one workbook to another
 

Hi,
I have two workbooks say(WB1 and WB2).I need to copy WB1 data into WB2.
Can anyone please help?

uha.

Create a macro to copy data from one workbook to another
 

A macro would be easy to create though I don't think it is necessary.

You have a number of options, some of the easier ones:
1. right click on the tab with the information you want to copy and select
'move or copy', select the other workbook and 'copy'. This is make a copy of
the entire sheet.
2. You could copy and "paste as link" if you want changes to update
automatically.
3. For writing a macro, try doing a record macro in target workbook, select
the information in the other workbook and select copy; go back and paste then
turn off the record macro. Then go and read the macro information in VBA (Alt
F11)


"uha" wrote:

Hi,
I have two workbooks say(WB1 and WB2).I need to copy WB1 data into WB2.
Can anyone please help?

uha.