Merge excel files

  • Thread starter Thread starter The Rook
  • Start date Start date
T

The Rook

I have approx 25 different excel file that i woul like to merge into one
file. Is this possible?
 
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
 
Hi

I want to copy all the sheets to one file

Kassie said:
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
Click to expand...
 
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
 
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?
 
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
 
Back
Top