hyperlink within sheet

[chaumay809]

hello,

i have an excel file that I need help with, attached.

in the sales sheet under the customer id, cell A2 [369700]; i want to create some kind of a hyperlink that If hit on this cell A2, it will bring me to the bottom of the sheet 369700which i can eaisly see the last sales is 19594 in [sheet 369700] CellA47. This should not limit to cellA47 as the data will continue, so the function should go to the biggest sale# in column A.



any help is appreciated.

thanks Tiger.

[stephenloky]

I think pivot table is your solution. Make a pivot table from all your data and If you double click in a "Sum of something" then It will bring you to the Data that it has originated from.
12345.xls

[chaumay809]

hi stephen,

i don't need the sum total, I need only the Sale#.
in my case, it would be: 19594.

[stephenloky]

Hey, you just need to drag the filters to adjust to your needs.

[chaumay809]

this is still not what i want.
if i changed the file to Invoice, it would show me the sum.
i want to see only the max. invoice#. in my case it would be: 19594

I appologized if I didnt make myself clear.

[stephenloky]

Hey! You still can do that with pivot table, instead of SUM SOmething, I made a "Max of Invoice" and It worked! (I changed the max invoice for the other customer just for example purposes) Tell me if you have any questions!