Hello,

I have a file (named P04-2009) where the cells need to link to last month's
file's cell (same cell) (file named P03-2009). How can I have a macro to
automatically update cell to last monthly file automatically when I work on
current month file?

Thanks a lot

Hank

Hi

i have a solution other than macro:

assuming that you are replicating the same file month on month (i.e. you copy
the previous month file to work on current month)

for one month you need to manually link the cells to previous month file
(this is one time task)

Using Edit links you can relink it to desired month file. to do this

Go to Edit Links in the popup window u can see the number external
workbooks linked to current workbook to relink it to proper file select the
file you want to relink and then click change source, this action will open
the file window now you can choose the desired file and then click ok.

This feature automatically relink the references to desired workbook.

regards
rajesh

"Hank" wrote:

Hello,

I have a file (named P04-2009) where the cells need to link to last month's
file's cell (same cell) (file named P03-2009). How can I have a macro to
automatically update cell to last monthly file automatically when I work on
current month file?

Thanks a lot

Hank

Thanks Rajesh, never used link b4, it is cool.

Hank

"rajesh" wrote:

Hi

i have a solution other than macro:

assuming that you are replicating the same file month on month (i.e. you copy
the previous month file to work on current month)

for one month you need to manually link the cells to previous month file
(this is one time task)

Using Edit links you can relink it to desired month file. to do this

Go to Edit Links in the popup window u can see the number external
workbooks linked to current workbook to relink it to proper file select the
file you want to relink and then click change source, this action will open
the file window now you can choose the desired file and then click ok.

This feature automatically relink the references to desired workbook.

regards
rajesh

"Hank" wrote:

Hello,

I have a file (named P04-2009) where the cells need to link to last month's
file's cell (same cell) (file named P03-2009). How can I have a macro to
automatically update cell to last monthly file automatically when I work on
current month file?

Thanks a lot

Hank