Merge excel files

T

The Rook

I have approx 25 different excel file that i woul like to merge into one
file. Is this possible?
 
K

Kassie

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
 
T

The Rook

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...
 
K

Kassie

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
 
T

The Rook

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?
 
T

The Rook

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
 
Top