copy data from diff workbooks

**bhimanand** · 11-13-2012, 12:07 PM

hello everyone

I am looking for a vba code that willl help me collate data from multiple workbooks into one master workbook.
The range to be copied from all the workbooks will be same. range a18:f18

**arlu1201** · 11-13-2012, 12:17 PM

Try this code

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose Insert | Macro | Macros
Select a macro in the list, and click the Run button

**bhimanand** · 11-14-2012, 09:15 AM

Thanks a Lot Arlette, This has been very useful... I just wanted some modification in the code

If i can select the source work books through the open files menu &
The data pasted in the master work book should be in paste special values

Thanks & Regards,
Bhima

**arlu1201** · 11-15-2012, 01:43 AM

The code has been edited to take care of pastespecial values. Do you want the macro to give the popup for each file to be opened?

**bhimanand** · 11-15-2012, 08:56 AM

i need a popup to select all the required files at one go

**arlu1201** · 11-15-2012, 11:16 AM

Try this code

Please Login or Register  to view this content.

**scousemouse** · 11-20-2012, 04:07 PM

I have a similar problem, I need to copy data from 3 different workbooks which have a tab with the owners name say Bill, Fred, Ann.

worksheet are called Bill Cat Work Log.xls, Fred Cat Work Log.xls & Ann Cat Work Log.xla

The data from each workbook needs to be copied into a master workbook called work log.xls with tab called results. A button on the results tab will run the macro

Can anybody help?

**arlu1201** · 11-21-2012, 06:21 AM

Scousemouse,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.