Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
data from many work books
How do I collect data from many workbooks from select columns into a single
workbook automatically. I don't want to open each one manually and copy and paste from it to the main workbook. The system should ask me for which file to be opened. Please can you help. Thanks and regards, Sandeep S. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
data from many work books
This can be done with VBA code (a macro). You haven't given enough
information to provide a more detailed answer, but there is one command available that does allow you to browse and identify files to be worked with that will probably end up in the code: Application.GetOpenFilename will return a filename from a dialog box, and then the code can open that file and perform operations to copy information from that file into another workbook. I've found that an easier way to do this kind of thing with many workbooks is to copy all of the workbooks into a single folder dedicated for the use, and have the VBA code go through all files in that folder looking for Excel files and then opening each one in turn and processing the data as required. "Sandeep S." wrote: How do I collect data from many workbooks from select columns into a single workbook automatically. I don't want to open each one manually and copy and paste from it to the main workbook. The system should ask me for which file to be opened. Please can you help. Thanks and regards, Sandeep S. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
data from many work books
See Ron de Bruin's site for code.
http://www.rondebruin.nl/copy3.htm Assumes all workbooks are in a single folder. Gord Dibben MS Excel MVP On Mon, 23 Nov 2009 02:24:01 -0800, Sandeep S. <Sandeep wrote: How do I collect data from many workbooks from select columns into a single workbook automatically. I don't want to open each one manually and copy and paste from it to the main workbook. The system should ask me for which file to be opened. Please can you help. Thanks and regards, Sandeep S. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to work in a 3-d reference with 2 work books | Excel Worksheet Functions | |||
need a function that will work using multiple work books and sheet | Excel Worksheet Functions | |||
Consolidating Many Work Books with Little Data | Excel Worksheet Functions | |||
Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
Work books | Excel Worksheet Functions |