P Phil Jul 11, 2004 #1 I have 16 separate .xls worksheets how do import them so I have all 16 in one workbook? TIA
R Ragdyer Jul 11, 2004 #2 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.
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.
F Frank Kabel Jul 11, 2004 #3 Hi if you're looking for an automatic / macro solution have a look at Ron's site: http://www.rondebruin.nl/copy3.htm#sheet
Hi if you're looking for an automatic / macro solution have a look at Ron's site: http://www.rondebruin.nl/copy3.htm#sheet
P Phil Jul 12, 2004 #4 Perfect, thank you Frank Kabel said: Hi if you're looking for an automatic / macro solution have a look at Ron's site: http://www.rondebruin.nl/copy3.htm#sheet Click to expand...
Perfect, thank you Frank Kabel said: Hi if you're looking for an automatic / macro solution have a look at Ron's site: http://www.rondebruin.nl/copy3.htm#sheet Click to expand...
