Create a macro to copy data from one workbook to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

uha.
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to push data to another workbook 0
macro help 2
Macro Help CONT 2003 1
Excel 2003 + export of data 7
Macro to email to address in cell reference 1
Coding issue with Excel 2003 1
Excel help please, Button to export data 6
Copying Formulas from Workbook to Workbook 3

Back
Top