link from tab to tab

[BSBECK]

Using Excel 2003 – I have two tabs one has detail info for unit cost; the second has summery info for each unit. What I’d like to do is if you are on the summery tab and click on a unit number, then if you go to the detail tab it will be at the first unit with that number



Thanks
Brad

[Palmetto]

Options:

Create a hyperlink to the cells manually using the built-in bookmarking function. See the Excel Help on: Create a hyperlink to a specific location in a workbook

Use VBA to find the value on the sheet and navigate if found.
If you need a VBA solution, upload a sample workbook (remove sensitive data)

[BSBECK]

I have added a link to a sample.

[JBeaucaire]

I have added a link to a sample.

Where?

Also, you should post workbooks here, not on other sites. Click GO ADVANCED and use the paperclip icon to post up your workbook.

[JBeaucaire]

1) I corrected the spelling of your sheet tabs to Summary and Detail.


2) If you don't want to be manually editing all those hyperlinks, then insert a new empty column A, then put this formula in A2, then copy it down:

=HYPERLINK("#"& "Detail!" & ADDRESS(MATCH($B2, Detail!$A:$A, 0), 1), "Link")

Now if you click on any of those links, it will take you to second sheet and the first row with that value.

[BSBECK]

1) I corrected the spelling of your sheet tabs to Summary and Detail.


2) If you don't want to be manually editing all those hyperlinks, then insert a new empty column A, then put this formula in A2, then copy it down:

Now if you click on any of those links, it will take you to second sheet and the first row with that value.

Sorry,, I haven’t done this much. I have added file to original post. If you would be so kind as to change as you need and let me see what needs to be done, I’d greatly appreciate it.

[JBeaucaire]

The instructions were in that post. I can break them out for you:

1) Insert an empty column in front of column A, so column A is now empty and your data starts at column B

2) In the new empty column, put the formula given in A2. A hyperlink will appear based on the value in B2.

3) Now copy cell A2 down the A column as far as needed.

4) All the links will be for each row. Click any link to jump to the detail sheet.

[BSBECK]

Sorry once again. I thought you had made a working version when you said you had corrected the spelling errors I made but I couldn’t find it, that’s way I ask.

I did get it to work from your help, many thanks for that! but you guys need to be a little nicer, seems to be a lot of sarcasm on this forum. If I had gotten it the first time, I wouldn’t have asked again. Buy the way…I think you meant “is now” not “is not” in (line 1) of your last post. See how it’s easy to make a typo…I new what you meant and would not normally said anything but wonted you to see how petty one can be.

Thanks again for the help.

[JBeaucaire]

BSBECK, on the forum when one is given clear instructions, it is perfectly reasonable to point an OP back to them. I also delineated those instructions in even more detail to assist you further. The goal, where possible, is to have an OP implement the solution themselves, which you did, with my help.

There isn't a single sarcastic comment from me in this entire thread. Just clear free informed assistance to you. Any sarcastic tone is being added accidentally by your reading.

I pointed out your typos because they are important to getting the formulas to work properly.

You pointed out a meaningless typo of mine because you are possibly being the petty one with an itchy emotional-trigger-finger and you clearly do not understand the value of the assistance you have gotten.

Reread my instructions, reevaluate all I said (not including this post) and I am sure you will find you have made a complete misread. I expect an apology and a sincere thanks in its place is in order, don't you think?

The last thing you want to do is burn any bridges around here, this place is an awesome resource, as you've already discovered. Even if someone actually does get sarcastic with you, unlike this thread, I'm confident you can take it in stride. Next time, yes?