someone must know !

[Phil]

I have 16 separate .xls worksheets how do import them so I have all
16 in
one workbook?

TIA

 

[Ragdyer]

I would suggest that you start with opening two of them, of which one will
be the intended *main* one.
Right click the tab of the *secondary* sheet and choose "Move or Copy".
In the "ToBook" window, click on the name of the *main*, then <OK>.

Now, simply open the rest and repeat the steps.

 

[Frank Kabel]

Hi
if you're looking for an automatic / macro solution have a look at
Ron's site:
http://www.rondebruin.nl/copy3.htm#sheet

 

[Phil]

Perfect, thank you

Hi
if you're looking for an automatic / macro solution have a look at
Ron's site:
http://www.rondebruin.nl/copy3.htm#sheet