 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2007how do I insert a cell value in a hyperlink formula
I need to insert a value from another cell in the same spreadsheet say B2 to replace nnnnnn in the following hyperlink and have tried &B2, "B2","&B2&" !B2, =B2, nothing seems to work. Any ideas? Thanks in advance. http://domweb21.bank.net/apps/ecms/CCAApp.nsf/wwwApprLkup?ReadForm&Multi=No&Next Step=Close&ATxCrNum&Annnnnn&Annnnnn&ANorm Maybe... =HYPERLINK("http://domweb21.bank.net/apps/ecms/CCAApp.nsf/wwwApprLkup?" &"ReadForm&Multi=No&NextStep=Close&ATxCrNum&A"&B2&"&A"&B2&"&Anorm","click me") If that value in B2 has to be formatted, you may want something like: =HYPERLINK("http://domweb21.bank.net/apps/ecms/CCAApp.nsf/wwwApprLkup?" &"ReadForm&Multi=No&NextStep=Close&ATxCrNum&A"&text(B2,"0000") &"&A"&text(B2,"0000")&"&Anorm","click me") > I need to insert a value from another cell in the same spreadsheet say B2 to > replace nnnnnn in the following hyperlink and have tried &B2, "B2","&B2&" > !B2, =B2, nothing seems to work. Any ideas? Thanks in advance. > > http://domweb21.bank.net/apps/ecms/CCAApp.nsf/wwwApprLkup?ReadForm&Multi=No&Next Step=Close&ATxCrNum&Annnnnn&Annnnnn&ANorm  SignatureDave Peterson
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.