Update workbook each time a different worksheet is selected
 

I need to update a workbook each time the user goes to a new worksheet either
by selecting the tab for that worksheet or by hyperlink. How can I to this
without using a macro? (using macro is ok if necessary but I am trying to
keep things simple)

Update workbook each time a different worksheet is selected
 

DJ

"Update" means what?

More details please.


Gord Dibben Excel MVP

On Tue, 13 Dec 2005 13:50:02 -0800, DJL wrote:

I need to update a workbook each time the user goes to a new worksheet either
by selecting the tab for that worksheet or by hyperlink. How can I to this
without using a macro? (using macro is ok if necessary but I am trying to
keep things simple)

Update workbook each time a different worksheet is selected
 

This does what I need.

=VALUE(REPLACE((MID(CELL("filename",A1), FIND("]", CELL("filename", A1))+ 1,
255)),1,1," "))

Where the names are W1, W2, Wn and all I need is the numeric part of the tab
name.

This was adapted from what I found on this web site:

http://www.mcgimpsey.com/excel/formu..._function.html


"Gord Dibben" wrote:

DJ

"Update" means what?

More details please.


Gord Dibben Excel MVP

On Tue, 13 Dec 2005 13:50:02 -0800, DJL wrote:

I need to update a workbook each time the user goes to a new worksheet either
by selecting the tab for that worksheet or by hyperlink. How can I to this
without using a macro? (using macro is ok if necessary but I am trying to
keep things simple)