Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging to identical Excel files
Greetings all,
I have about 30 Excel files that all contain the exact same columns but different data. Is there a way to merge all 30 files into one €śmaster€ť Excel file? Thanks in advance for your help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging to identical Excel files
cut and paste, cut and paste.
you CAN make a macro to do it, but I'll offer an alternative suggestion..... For data storage, access is truly the right tool, but we'll stick with excel for now. I'm assuming that each different workbook or sheet has a different function. Add ONE column to each sheet and put in that column the name of the workbook/worksheet/whatever. Then combine all your data. Going forward, keep all of the data together. Use Autofilter to split it out if you need to.. I could go into more depth, BUT it is much easier to pull data out for reporting, than it is to combine it if it's all stored seperately. Just a matter of approach. "Word problems" wrote: Greetings all, I have about 30 Excel files that all contain the exact same columns but different data. Is there a way to merge all 30 files into one €śmaster€ť Excel file? Thanks in advance for your help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging to identical Excel files
Tom,
Thanks for your help. Since posting my message I have found this "add-in", though a bit funky it did what I needed it to do. http://www.digdb.com/excel_add_ins/c..._sheets_files/ Thanks again for your help. "TomHinkle" wrote: cut and paste, cut and paste. you CAN make a macro to do it, but I'll offer an alternative suggestion..... For data storage, access is truly the right tool, but we'll stick with excel for now. I'm assuming that each different workbook or sheet has a different function. Add ONE column to each sheet and put in that column the name of the workbook/worksheet/whatever. Then combine all your data. Going forward, keep all of the data together. Use Autofilter to split it out if you need to.. I could go into more depth, BUT it is much easier to pull data out for reporting, than it is to combine it if it's all stored seperately. Just a matter of approach. "Word problems" wrote: Greetings all, I have about 30 Excel files that all contain the exact same columns but different data. Is there a way to merge all 30 files into one €śmaster€ť Excel file? Thanks in advance for your help. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging to identical Excel files
Try this
http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Word problems" wrote in message ... Greetings all, I have about 30 Excel files that all contain the exact same columns but different data. Is there a way to merge all 30 files into one "master" Excel file? Thanks in advance for your help. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging to identical Excel files
Thanks Ron. I will give your solutions a try. It looks a little complex to
setup but I think it will be cheaper in the long run. "Ron de Bruin" wrote: Try this http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Word problems" wrote in message ... Greetings all, I have about 30 Excel files that all contain the exact same columns but different data. Is there a way to merge all 30 files into one "master" Excel file? Thanks in advance for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I get excel at start up to only open excel files? | Excel Discussion (Misc queries) | |||
Merging in Excel from Word, Excel, or Access | Excel Discussion (Misc queries) | |||
Merging cells in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel Files Acting Weird | Excel Discussion (Misc queries) | |||
Excel Files Won't Open From Shortcut | Excel Discussion (Misc queries) |