sample.xlsx
workbook with several worksheet. this is a sample. on the TOTAL worksheet, i would love to have an hyperlink that when clicked on the RO#, takes me to that worksheet. example, i clikc on 6404, takes me to the 6404 worksheet. i go right click add hyperlink, but too many worksheets to manual add each. is there a simpler hyperlink formula that looks up the ro# and takes me to the ro# worksheet.
thanks!
Last edited by axidburn; 12-22-2011 at 05:17 PM.
Hi
Are you wanting to go to the sheet called RO#6404? Is that right? If so, can you use something like =hyperlink(concatenate(location of your file etc,"RO#",A8)).
Does that make sense? You would have to add an additional column into the TOTAL sheet though.
Woozer - sorry, but i cannot program in excel. but you are correct. i need to click on 6404 on the TOTAL page and send me directly to the 6404 worksheet. i would appreciate a complete formula since i have no idea how to finish it.
thanks.
sample.xlsxHey Axidburn
Try the attached file to see if it makes sense. You can land on a specified cell if you need to as well.
The line for the cell would be like: =HYPERLINK(CONCATENATE("'",A50,"'!A1"),A50)
Does that help at all?
WOOZER, stupid question, but how do i apply this formula to my worksheet. thanks
Use this in Total tab A4, then copy down.
=HYPERLINK("#'"&ROWS(A$4:A4)+6399&"'!E1",ROWS(A$4:A4)+6399)
When you click on it, this take you to E1
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
haseeb, thanks. worked fine.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks