Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge excel files
I have approx 25 different excel file that i woul like to merge into one
file. Is this possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge excel files
It's possible yes. Do you want to copy the sheets from these files into one
file, or do you want to extract info from these into one worksheet? -- HTH Kassie Replace xxx with hotmail "The Rook" wrote: I have approx 25 different excel file that i woul like to merge into one file. Is this possible? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge excel files
Hi
I want to copy all the sheets to one file "Kassie" wrote: It's possible yes. Do you want to copy the sheets from these files into one file, or do you want to extract info from these into one worksheet? -- HTH Kassie Replace xxx with hotmail "The Rook" wrote: I have approx 25 different excel file that i woul like to merge into one file. Is this possible? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge excel files
I take it you still want each sheet seperate?
If so, insert sheets in your file. Now open each of the other files, click on the sqaure above A and to the left of 1, press <Ctrl<C, go the the destination sheet, click in A1, and press <Ctrl<V. If you want to copy into one sheet, click on A1 in the source sheet, press and hold <Shift, and click <End & <Home to select the used range of that sheet. <Ctrl<C, back to the destination sheet, press <End<Home, then down arrow, then <End<Left, then <Ctrl<V -- HTH Kassie Replace xxx with hotmail "The Rook" wrote: Hi I want to copy all the sheets to one file "Kassie" wrote: It's possible yes. Do you want to copy the sheets from these files into one file, or do you want to extract info from these into one worksheet? -- HTH Kassie Replace xxx with hotmail "The Rook" wrote: I have approx 25 different excel file that i woul like to merge into one file. Is this possible? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge excel files
See
http://www.rondebruin.nl/fso.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "The Rook" wrote in message ... Hi I want to copy all the sheets to one file "Kassie" wrote: It's possible yes. Do you want to copy the sheets from these files into one file, or do you want to extract info from these into one worksheet? -- HTH Kassie Replace xxx with hotmail "The Rook" wrote: I have approx 25 different excel file that i woul like to merge into one file. Is this possible? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge excel files
Thanks for that, but unfortunatley I am not very good with VBA!
I have tryied to following the instructions for RDB_Copy_Sheet, I have chenged the 'MyPath' to the file location, then run the macro, but get a 'Compile error: Sub or Function not defined' messge, and it highlights the 'Sub RDB_Copy_Sheet()' at the beginning of the macro. Am I meant to change this to something or am I way of the mark? "Ron de Bruin" wrote: See http://www.rondebruin.nl/fso.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "The Rook" wrote in message ... Hi I want to copy all the sheets to one file "Kassie" wrote: It's possible yes. Do you want to copy the sheets from these files into one file, or do you want to extract info from these into one worksheet? -- HTH Kassie Replace xxx with hotmail "The Rook" wrote: I have approx 25 different excel file that i woul like to merge into one file. Is this possible? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge excel files
Managed got get the addins working, excellent piece of work but not exactly
what I wanted. I want it to bring the worksheets from each file into one file (seperate sheets) But thanks anyway regards "Ron de Bruin" wrote: See http://www.rondebruin.nl/fso.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "The Rook" wrote in message ... Hi I want to copy all the sheets to one file "Kassie" wrote: It's possible yes. Do you want to copy the sheets from these files into one file, or do you want to extract info from these into one worksheet? -- HTH Kassie Replace xxx with hotmail "The Rook" wrote: I have approx 25 different excel file that i woul like to merge into one file. Is this possible? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge excel files
I will add this when I update the add-in
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "The Rook" wrote in message ... Managed got get the addins working, excellent piece of work but not exactly what I wanted. I want it to bring the worksheets from each file into one file (seperate sheets) But thanks anyway regards "Ron de Bruin" wrote: See http://www.rondebruin.nl/fso.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "The Rook" wrote in message ... Hi I want to copy all the sheets to one file "Kassie" wrote: It's possible yes. Do you want to copy the sheets from these files into one file, or do you want to extract info from these into one worksheet? -- HTH Kassie Replace xxx with hotmail "The Rook" wrote: I have approx 25 different excel file that i woul like to merge into one file. Is this possible? |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge excel files
Test the code in the workbook that you can download
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "The Rook" wrote in message ... Thanks for that, but unfortunatley I am not very good with VBA! I have tryied to following the instructions for RDB_Copy_Sheet, I have chenged the 'MyPath' to the file location, then run the macro, but get a 'Compile error: Sub or Function not defined' messge, and it highlights the 'Sub RDB_Copy_Sheet()' at the beginning of the macro. Am I meant to change this to something or am I way of the mark? "Ron de Bruin" wrote: See http://www.rondebruin.nl/fso.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "The Rook" wrote in message ... Hi I want to copy all the sheets to one file "Kassie" wrote: It's possible yes. Do you want to copy the sheets from these files into one file, or do you want to extract info from these into one worksheet? -- HTH Kassie Replace xxx with hotmail "The Rook" wrote: I have approx 25 different excel file that i woul like to merge into one file. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge Two Excel Files by Key | Excel Worksheet Functions | |||
merge files in Excel? | Excel Discussion (Misc queries) | |||
merge data from 2 Excel files | Excel Worksheet Functions | |||
how i can merge more than two excel files in one file. | New Users to Excel | |||
How do I merge two files in Excel? | Excel Discussion (Misc queries) |