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 <(E-Mail Removed)> 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 <(E-Mail Removed)> 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".
>
>