Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I update links based on a cell value?
I'm trying to update links based on a cell value.
For Example: A1 thru A4 has the values 21,22,23, and 24 respectivly. My link in B2 is ='C:\temp\[Cash Report 12-22-05.xls]Sheet1'!$D$5. Is there a way that I can have the link in B2, change to 12-23-05(A2's Value) without doing a manual find and replace for each cell? If there is a macro way to do this that would be great too. Thanks in Adavance! Vick |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I update links based on a cell value?
If the resulting file name will be open, you can use =indirect(). But that will
fail if the "sending" workbook is closed. How about just Edit|Links|change source? Vick wrote: I'm trying to update links based on a cell value. For Example: A1 thru A4 has the values 21,22,23, and 24 respectivly. My link in B2 is ='C:\temp\[Cash Report 12-22-05.xls]Sheet1'!$D$5. Is there a way that I can have the link in B2, change to 12-23-05(A2's Value) without doing a manual find and replace for each cell? If there is a macro way to do this that would be great too. Thanks in Adavance! Vick -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I update links based on a cell value?
are there anyway to work around the limitation that the sending file needs to
be open? regards Gerrit "Dave Peterson" wrote: If the resulting file name will be open, you can use =indirect(). But that will fail if the "sending" workbook is closed. How about just Edit|Links|change source? Vick wrote: I'm trying to update links based on a cell value. For Example: A1 thru A4 has the values 21,22,23, and 24 respectivly. My link in B2 is ='C:\temp\[Cash Report 12-22-05.xls]Sheet1'!$D$5. Is there a way that I can have the link in B2, change to 12-23-05(A2's Value) without doing a manual find and replace for each cell? If there is a macro way to do this that would be great too. Thanks in Adavance! Vick -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I update links based on a cell value?
Check your other post for more replies.
Gerrit wrote: are there anyway to work around the limitation that the sending file needs to be open? regards Gerrit "Dave Peterson" wrote: If the resulting file name will be open, you can use =indirect(). But that will fail if the "sending" workbook is closed. How about just Edit|Links|change source? Vick wrote: I'm trying to update links based on a cell value. For Example: A1 thru A4 has the values 21,22,23, and 24 respectivly. My link in B2 is ='C:\temp\[Cash Report 12-22-05.xls]Sheet1'!$D$5. Is there a way that I can have the link in B2, change to 12-23-05(A2's Value) without doing a manual find and replace for each cell? If there is a macro way to do this that would be great too. Thanks in Adavance! Vick -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating for a cell based on another cell's value | Excel Discussion (Misc queries) | |||
Update links prompt not wanted | Excel Discussion (Misc queries) | |||
Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) | |||
Update Cell Value Based on different Cell | Excel Discussion (Misc queries) | |||
Returning a Value to a Cell Based on a Range of Uncertain Size | Excel Worksheet Functions |