Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying data from multiple file into one file
Hello,
I have around 150 files having same Column headings and around 200 records under rows. I want to creat one big file to have all the records from these 150 files. Is there a easy way to do that ? Please advise and thanks for help. Dinesh |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying data from multiple file into one file
Hi nsd
Is there a easy way to do that ? Install this add-in http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "nsd" wrote in message ... Hello, I have around 150 files having same Column headings and around 200 records under rows. I want to creat one big file to have all the records from these 150 files. Is there a easy way to do that ? Please advise and thanks for help. Dinesh |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying data from multiple file into one file
Thank you so very much. It saved me big time.
I have a quick question though. The file generates 2 sheets namely "Combine Sheet and "Log Sheet". Do i need to keep it that way or I can delete the log sheet and the Column A of Combine sheet, as it has the name/location of files. Please advise. And thanks once again. Dinesh "Ron de Bruin" wrote: Hi nsd Is there a easy way to do that ? Install this add-in http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "nsd" wrote in message ... Hello, I have around 150 files having same Column headings and around 200 records under rows. I want to creat one big file to have all the records from these 150 files. Is there a easy way to do that ? Please advise and thanks for help. Dinesh |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying data from multiple file into one file
The log sheet is only info so you can delete that
and the Column A of Combine sheet, as it has the name/location of files. You can turn this of on the userform -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "nsd" wrote in message ... Thank you so very much. It saved me big time. I have a quick question though. The file generates 2 sheets namely "Combine Sheet and "Log Sheet". Do i need to keep it that way or I can delete the log sheet and the Column A of Combine sheet, as it has the name/location of files. Please advise. And thanks once again. Dinesh "Ron de Bruin" wrote: Hi nsd Is there a easy way to do that ? Install this add-in http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "nsd" wrote in message ... Hello, I have around 150 files having same Column headings and around 200 records under rows. I want to creat one big file to have all the records from these 150 files. Is there a easy way to do that ? Please advise and thanks for help. Dinesh |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying data from multiple file into one file
Ok got it Sir.
Thank you very much for this help. Really appreciate it. Dinesh "Ron de Bruin" wrote: The log sheet is only info so you can delete that and the Column A of Combine sheet, as it has the name/location of files. You can turn this of on the userform -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "nsd" wrote in message ... Thank you so very much. It saved me big time. I have a quick question though. The file generates 2 sheets namely "Combine Sheet and "Log Sheet". Do i need to keep it that way or I can delete the log sheet and the Column A of Combine sheet, as it has the name/location of files. Please advise. And thanks once again. Dinesh "Ron de Bruin" wrote: Hi nsd Is there a easy way to do that ? Install this add-in http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "nsd" wrote in message ... Hello, I have around 150 files having same Column headings and around 200 records under rows. I want to creat one big file to have all the records from these 150 files. Is there a easy way to do that ? Please advise and thanks for help. Dinesh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Multiple files in one file Macro - Liz | New Users to Excel | |||
Copying & Filling in data from One file into another. | Excel Worksheet Functions | |||
copying data from an unopened file programmatically | Excel Discussion (Misc queries) | |||
Copying many tabs from one file to an individual file for each tab | Excel Discussion (Misc queries) | |||
Copying the Editing in one file to Another opened XLS file | Excel Worksheet Functions |