| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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) |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find a value in a workbook and return the worksheet name | Excel Discussion (Misc queries) | |||
| Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
| Linking cells in a worksheet to other worksheets in a workbook | Excel Discussion (Misc queries) | |||
| How do I protect a worksheet from being opened inside a workbook | Excel Discussion (Misc queries) | |||
| copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions | |||
Hybrid Mode
