| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Gather data from multiple excel files into one master excel file
I need to gather information from multiple files that all have the same
layout but different information. Is it possible to update this information into one master excel file from the other files??? Regards Mark Allen |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Gather data from multiple excel files into one master excel file
Hi Mark
See http://msdn.microsoft.com/en-us/library/cc837974.aspx Or check out my website -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mark Allen" wrote in message ... I need to gather information from multiple files that all have the same layout but different information. Is it possible to update this information into one master excel file from the other files??? Regards Mark Allen |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Gather data from multiple excel files into one master excel fi
Hi Ron,
I am a complete novice to Visual Basic, I have looked at your sites and sorry but I am not sure what to do ??? Can you help please?? Mark "Ron de Bruin" wrote: Hi Mark See http://msdn.microsoft.com/en-us/library/cc837974.aspx Or check out my website -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mark Allen" wrote in message ... I need to gather information from multiple files that all have the same layout but different information. Is it possible to update this information into one master excel file from the other files??? Regards Mark Allen |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Gather data from multiple excel files into one master excel fi
I am a complete novice to Visual Basic
See http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mark Allen" wrote in message ... Hi Ron, I am a complete novice to Visual Basic, I have looked at your sites and sorry but I am not sure what to do ??? Can you help please?? Mark "Ron de Bruin" wrote: Hi Mark See http://msdn.microsoft.com/en-us/library/cc837974.aspx Or check out my website -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mark Allen" wrote in message ... I need to gather information from multiple files that all have the same layout but different information. Is it possible to update this information into one master excel file from the other files??? Regards Mark Allen |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Gather data from multiple excel files into one master excel fi
Ron,
I have now completely lost myself... I have managed to fetch some data back but may be I have not explained correctly what I am looking to do: All the following files are in a folder "c:\OP Funnel" I have one master file called "Funnel OP Master.xls" I have six additional files called "Funnel OP 1.xls, 2.xls, 3.xls, 4.xls, 5.xls, 6.xls" I need to merge the data from "A36:E36" through to "A300:E300" if there is data there from the above six files I need to merge all this data in the file "Funnel OP Master.xls" into the range "A36:E36" through to "A10000:E10000". I am really not sure how to do this looking at your formulas in Visual basic.. I would very much appreciate your help on this subject Regards Mark "Ron de Bruin" wrote: Hi Mark See http://msdn.microsoft.com/en-us/library/cc837974.aspx Or check out my website -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mark Allen" wrote in message ... I need to gather information from multiple files that all have the same layout but different information. Is it possible to update this information into one master excel file from the other files??? Regards Mark Allen |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Gather data from multiple excel files into one master excel fi
Hi Mark
My code and the add-in create a new workbook with the data You can change the code to copy it in a existing workbook but first try the code and see if it is working. If it is working post back and post your code so I can change it -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mark Allen" wrote in message ... Ron, I have now completely lost myself... I have managed to fetch some data back but may be I have not explained correctly what I am looking to do: All the following files are in a folder "c:\OP Funnel" I have one master file called "Funnel OP Master.xls" I have six additional files called "Funnel OP 1.xls, 2.xls, 3.xls, 4.xls, 5.xls, 6.xls" I need to merge the data from "A36:E36" through to "A300:E300" if there is data there from the above six files I need to merge all this data in the file "Funnel OP Master.xls" into the range "A36:E36" through to "A10000:E10000". I am really not sure how to do this looking at your formulas in Visual basic.. I would very much appreciate your help on this subject Regards Mark "Ron de Bruin" wrote: Hi Mark See http://msdn.microsoft.com/en-us/library/cc837974.aspx Or check out my website -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mark Allen" wrote in message ... I need to gather information from multiple files that all have the same layout but different information. Is it possible to update this information into one master excel file from the other files??? Regards Mark Allen |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Gather data from multiple excel files into one master excel fi
RDBMERGE works great...does what I need...
Now how do I get it to populated an exsiting workbook... Star man... Regards Mark "Ron de Bruin" wrote: Hi Mark My code and the add-in create a new workbook with the data You can change the code to copy it in a existing workbook but first try the code and see if it is working. If it is working post back and post your code so I can change it -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mark Allen" wrote in message ... Ron, I have now completely lost myself... I have managed to fetch some data back but may be I have not explained correctly what I am looking to do: All the following files are in a folder "c:\OP Funnel" I have one master file called "Funnel OP Master.xls" I have six additional files called "Funnel OP 1.xls, 2.xls, 3.xls, 4.xls, 5.xls, 6.xls" I need to merge the data from "A36:E36" through to "A300:E300" if there is data there from the above six files I need to merge all this data in the file "Funnel OP Master.xls" into the range "A36:E36" through to "A10000:E10000". I am really not sure how to do this looking at your formulas in Visual basic.. I would very much appreciate your help on this subject Regards Mark "Ron de Bruin" wrote: Hi Mark See http://msdn.microsoft.com/en-us/library/cc837974.aspx Or check out my website -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mark Allen" wrote in message ... I need to gather information from multiple files that all have the same layout but different information. Is it possible to update this information into one master excel file from the other files??? Regards Mark Allen |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Gather data from multiple excel files into one master excel fi
Which code example have you try ?
I will not change the add-in for this but can show you how to change the code -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mark Allen" wrote in message ... RDBMERGE works great...does what I need... Now how do I get it to populated an exsiting workbook... Star man... Regards Mark "Ron de Bruin" wrote: Hi Mark My code and the add-in create a new workbook with the data You can change the code to copy it in a existing workbook but first try the code and see if it is working. If it is working post back and post your code so I can change it -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mark Allen" wrote in message ... Ron, I have now completely lost myself... I have managed to fetch some data back but may be I have not explained correctly what I am looking to do: All the following files are in a folder "c:\OP Funnel" I have one master file called "Funnel OP Master.xls" I have six additional files called "Funnel OP 1.xls, 2.xls, 3.xls, 4.xls, 5.xls, 6.xls" I need to merge the data from "A36:E36" through to "A300:E300" if there is data there from the above six files I need to merge all this data in the file "Funnel OP Master.xls" into the range "A36:E36" through to "A10000:E10000". I am really not sure how to do this looking at your formulas in Visual basic.. I would very much appreciate your help on this subject Regards Mark "Ron de Bruin" wrote: Hi Mark See http://msdn.microsoft.com/en-us/library/cc837974.aspx Or check out my website -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mark Allen" wrote in message ... I need to gather information from multiple files that all have the same layout but different information. Is it possible to update this information into one master excel file from the other files??? Regards Mark Allen |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Gather data from multiple excel files into one master excel file
One way is to open each file and MOVE the sheets there to the master file -
Right Click on the sheet to MOVE and then select the BOOK (your master file) to move it to and the location in that BOOK. If you want to add the corresponding cells from all sheets to your master then that can also be done. "Mark Allen" wrote: I need to gather information from multiple files that all have the same layout but different information. Is it possible to update this information into one master excel file from the other files??? Regards Mark Allen |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link a Master Template Excel file to different excel source files | Excel Worksheet Functions | |||
| I have 1 master excel file & want to rec. data from 7 other files | Excel Worksheet Functions | |||
| linking multiple excel files to a master | Excel Discussion (Misc queries) | |||
| How to gather data from different excel workbooks into 1? | Excel Discussion (Misc queries) | |||
| Combine multiple Excel files into one master | Excel Discussion (Misc queries) | |||
Hybrid Mode
