Hi... Needing help from anyone who can assist with Excel 2007 for something from work. I have 2 problems within the 1 worksheet. I'm not any expert in excel, but so far I have my workbook where I need with exceptions to the 2 issues below. I have attached a test file for assistance so you can see the information that I need to match up.
Scenario: 1 workbook, with 2 sheets. I want the cells in Column A to hyperlink from the worksheet "Roster" to the cooresponding #'d cells in Column A on "Sheet2"
Problem 1 : I need to be able to copy and paste the formula so that I do not have to manually type it in for each time as the Roster sheet is expected to have at least 100 cells or more. Everytime I attempt this, it only refers to the first cell that I hyperlinked and none of the additional cells are changed. Additionally, i would like Sheet2 to also hyperlink back to the Roster sheet, so that the hyperlink works both ways.
Problem 2: When a new record is added to roster sheet, I would like it to automatically update on Sheet2, so that I do not have to type the information. Is this possible? Linking cells?
Thank you.
I have a bunch of 3-D hyperlink tricks list on my site on this page:
I used the second one on that page to get this suggestion for you... put this formula in C2, then copy down:
=HYPERLINK("#'Sheet2'!" & ADDRESS(MATCH($B2, Sheet2!$B:$B, 0), 1), "Link")
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks