linking cells in multiple workbooks

I want to type in certain cells on 5 different worksheets in one workbook;
and have that same data appear in 6 other workbooks. So I don't have to
retype or copy and paste the data in the other workbooks. Is there a way to
do this with a macro or some other linking feature in excel?

Hope this is clear thank you

You can simply add the filepath & file to your cell reference like this

='C:\MyFilePath\[MyExcelFile]Sheet1'!$A$1

This will create a link to this workbook. I believe the workbook that the
link is directed to has to be open to update the reference.

Alternatively, you could search this website for a built-in function being
developed called INDIRECT2 which will allow you to reference cells that will
update automatically without having the source spreadsheet open

Cheers!

Richard Reye


"sherobot" wrote:

> I want to type in certain cells on 5 different worksheets in one workbook;
> and have that same data appear in 6 other workbooks. So I don't have to
> retype or copy and paste the data in the other workbooks. Is there a way to
> do this with a macro or some other linking feature in excel?
>
> Hope this is clear thank you

Correction.

I forgot to add the website that is developing INDIRECT2.

Go to http://xcell05.free.fr/

Cheers!

"Richard Reye" wrote:

> You can simply add the filepath & file to your cell reference like this
>
> ='C:\MyFilePath\[MyExcelFile]Sheet1'!$A$1
>
> This will create a link to this workbook. I believe the workbook that the
> link is directed to has to be open to update the reference.
>
> Alternatively, you could search this website for a built-in function being
> developed called INDIRECT2 which will allow you to reference cells that will
> update automatically without having the source spreadsheet open
>
> Cheers!
>
> Richard Reye
>
>
> "sherobot" wrote:
>
> > I want to type in certain cells on 5 different worksheets in one workbook;
> > and have that same data appear in 6 other workbooks. So I don't have to
> > retype or copy and paste the data in the other workbooks. Is there a way to
> > do this with a macro or some other linking feature in excel?
> >
> > Hope this is clear thank you

Thanks Richard that works good for one workbook in one cell. Do you know how
I would code it for multiple workbooks to cover multiple cells? I tried to
put more than one workbook inside the brackets and it kept giving me errors.

sherobot

"Richard Reye" wrote:

> You can simply add the filepath & file to your cell reference like this
>
> ='C:\MyFilePath\[MyExcelFile]Sheet1'!$A$1
>
> This will create a link to this workbook. I believe the workbook that the
> link is directed to has to be open to update the reference.
>
> Alternatively, you could search this website for a built-in function being
> developed called INDIRECT2 which will allow you to reference cells that will
> update automatically without having the source spreadsheet open
>
> Cheers!
>
> Richard Reye
>
>
> "sherobot" wrote:
>
> > I want to type in certain cells on 5 different worksheets in one workbook;
> > and have that same data appear in 6 other workbooks. So I don't have to
> > retype or copy and paste the data in the other workbooks. Is there a way to
> > do this with a macro or some other linking feature in excel?
> >
> > Hope this is clear thank you