I am not sure how to combine information from multiple file into many
different files.
I have say 5 Excel file for each division: A, B... (each division file have
multiple workbooks (tabs) .
File name "Divison A" has tab for "Co 1 vs Co2", "Co 1 vs C0 3" etc,
File name "Divison B" has tabs for "Co 1 vs Co2", "Co 1 vs Co7". "Co 2 vs
Co4"etc
I need to create a seperate file that capture all the information that have
the same tab name from each Division.
e.g. The new files will be call "Co 1 vs Co2", "Co 1 vs Co7" etc... . within
this new file there will be 5 tabs for each division e.g. "Division A",
"Division B" etc, it will have exactly the same information from each tab
within the file "Division A" , "Division B" etc, together with the links and
format .
I can copy and paste each tab manually it is very time consuming, is there a
better and more efficient way of doing this without lossing the link from
each tab say "Co 1 vs Co2".
Also will any change in the "Division A" file be automatically update to the
file "Co 1 vs Co2".

See Ron de Bruin's site for code assistance.

http://www.rondebruin.nl/tips.htm

Browse through the section on Copy/Paste/Merge examples


Gord Dibben MS Excel MVP

On Sun, 8 Jun 2008 08:22:00 -0700, RW wrote:

I am not sure how to combine information from multiple file into many
different files.
I have say 5 Excel file for each division: A, B... (each division file have
multiple workbooks (tabs) .
File name "Divison A" has tab for "Co 1 vs Co2", "Co 1 vs C0 3" etc,
File name "Divison B" has tabs for "Co 1 vs Co2", "Co 1 vs Co7". "Co 2 vs
Co4"etc
I need to create a seperate file that capture all the information that have
the same tab name from each Division.
e.g. The new files will be call "Co 1 vs Co2", "Co 1 vs Co7" etc... . within
this new file there will be 5 tabs for each division e.g. "Division A",
"Division B" etc, it will have exactly the same information from each tab
within the file "Division A" , "Division B" etc, together with the links and
format .
I can copy and paste each tab manually it is very time consuming, is there a
better and more efficient way of doing this without lossing the link from
each tab say "Co 1 vs Co2".
Also will any change in the "Division A" file be automatically update to the
file "Co 1 vs Co2".

Thank you Gord, from the link you provided, will 'Create a workbook from
every worksheet in your workbook" work for my situation.
I am not familiar with VBE. any other suggestion you may have other than
using VBE

"Gord Dibben" wrote:

See Ron de Bruin's site for code assistance.

http://www.rondebruin.nl/tips.htm

Browse through the section on Copy/Paste/Merge examples


Gord Dibben MS Excel MVP

On Sun, 8 Jun 2008 08:22:00 -0700, RW wrote:

I am not sure how to combine information from multiple file into many
different files.
I have say 5 Excel file for each division: A, B... (each division file have
multiple workbooks (tabs) .
File name "Divison A" has tab for "Co 1 vs Co2", "Co 1 vs C0 3" etc,
File name "Divison B" has tabs for "Co 1 vs Co2", "Co 1 vs Co7". "Co 2 vs
Co4"etc
I need to create a seperate file that capture all the information that have
the same tab name from each Division.
e.g. The new files will be call "Co 1 vs Co2", "Co 1 vs Co7" etc... . within
this new file there will be 5 tabs for each division e.g. "Division A",
"Division B" etc, it will have exactly the same information from each tab
within the file "Division A" , "Division B" etc, together with the links and
format .
I can copy and paste each tab manually it is very time consuming, is there a
better and more efficient way of doing this without lossing the link from
each tab say "Co 1 vs Co2".
Also will any change in the "Division A" file be automatically update to the
file "Co 1 vs Co2".