Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Merging seperate workbooks into one workbook
Hi,
I am looking to merge a bunch of workbooks with one sheet in each of them into a single workbook with a bunch of sheets. All of the files are in the same folder. Once upon I time I downloaded a utility from microsoft.com that did this in a snap, but I cannot find it. Does anyone know where I can find that utility or how I can do this? Much thanks, Raoul Duke |
#2
|
|||
|
|||
Hi Raoul
Start here http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Raoul Duke" wrote in message ... Hi, I am looking to merge a bunch of workbooks with one sheet in each of them into a single workbook with a bunch of sheets. All of the files are in the same folder. Once upon I time I downloaded a utility from microsoft.com that did this in a snap, but I cannot find it. Does anyone know where I can find that utility or how I can do this? Much thanks, Raoul Duke |
#3
|
|||
|
|||
I found what I was looking for. There is an Excel 97 addin called
consolid.xla which is installed from consolid.exe. Run a search on microsoft.com for consolid.exe if you need it. It works on Excel 2000 and 2003. "Raoul Duke" wrote: Hi, I am looking to merge a bunch of workbooks with one sheet in each of them into a single workbook with a bunch of sheets. All of the files are in the same folder. Once upon I time I downloaded a utility from microsoft.com that did this in a snap, but I cannot find it. Does anyone know where I can find that utility or how I can do this? Much thanks, Raoul Duke |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
paste formulas between workbooks without workbook link | Excel Discussion (Misc queries) | |||
Refer to seperate workbook for validation list for drop downs? | Excel Discussion (Misc queries) | |||
Linking Workbooks | Excel Worksheet Functions | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) | |||
Merging data from several workbooks | Excel Worksheet Functions |