Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Search and Link across worksheets
As my ID suggests, I am far from expert level in Excel, but I find that two days of Google have not helped narrow down a solution, nor have I found an appropriate link elsewhere.
I need to set up an find/match/hyperlink in a template worksheet. Each deployment of the template will contain different data, but the sheet/cell references should remain consistent. Here's the deal - I would like to be able to say "In T4 on Sheet1, read the value of C4 on Sheet1, and search Sheet2, Table18 and put a link to the match (on Sheet2) in Sheet1, T4." (find Sheet1!C4 in Sheet2!Table18, insert link to Sheet2!<result in Sheet1!T4). Then, of course, carry this down the list for rows 5-999 on the source table in Sheet1. The basic idea is to allow the end users to click a link that will take them to another sheet with detailed data on the record that they are currently using. I have been going this alone, trying match, index, hyperlink, vlookup and combinations of the above. But I'm just not able to figure out the right combination. Is there anyone who may be able to help? Thank you in advance for your consideration and understanding. |
#2
|
|||
|
|||
Quote:
|
#3
|
|||
|
|||
Quote:
Any chance you could show us an example of the workbook to make it easier to understand the issue? Attach it here.
__________________
I hope it can help you. Best regards, Marcilio Lobăo --------------------------- Belo Horizonte, Brazil |
#4
|
|||
|
|||
Quote:
Please let me know if this requires any clarification. Thanks |
#5
|
|||
|
|||
Quote:
Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
search for a particular cell in worksheets | Excel Worksheet Functions | |||
search and link workbooks | Excel Discussion (Misc queries) | |||
Search all worksheets | Excel Programming | |||
Search all worksheets | Excel Programming | |||
search worksheets | Excel Discussion (Misc queries) |