| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a cell reference as part of a link
For example, if the tab of the link is 2-5, and the date in column A is
2/5/06, we want to link to ='[book2]2-5'!. Where 2-5 also corresponds to =month(A1)&"-"&day(A1), therefore changing the link to the tab associated with the date in A1, then A2, etc. Can we use a "formula" (month, day, etc.), in a link? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Q: Can a formula reference a cell to get the file name to link to for data? | Excel Discussion (Misc queries) | |||
| Input cell reference is not valid (One Variable Data Table) | Excel Worksheet Functions | |||
| Clicking Cell Link Changes Cell on Another Sheet | Excel Discussion (Misc queries) | |||
| Use Cell Content to Build Link | Excel Worksheet Functions | |||
| worksheet tab name as part of a cell reference | Excel Worksheet Functions | |||
Threaded Mode
