| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| $%Macro to Copy from one workbook to other when matching data | Excel Discussion (Misc queries) | |||
| Macro Help. Copy data from 1 workbook to another on next available | Excel Discussion (Misc queries) | |||
| Create macro to copy data on a scheduled basis | Excel Discussion (Misc queries) | |||
| Macro to copy data into another workbook | Excel Discussion (Misc queries) | |||
| Create Macro to Copy Data from one spreadsheet to another | Excel Discussion (Misc queries) | |||
Linear Mode
