hyperlink

[mrinal saha]

Hi Folks,

I'm in a situation where in an excel sheet I have hyperlinks in different cells which have a numeric value (assume:10) and in another cell there is text (assume: finance)

What i want is evertime you click the hyperlink , it takes you to another sheet where data gets sorted with finance to show those 10 records.

Can this be done??? Bit Urgent

Thanks,
Mrinal

 

[cummingsea]

Hi Folks,

I'm in a situation where in an excel sheet I have hyperlinks in different cells which have a numeric value (assume:10) and in another cell there is text (assume: finance)

What i want is evertime you click the hyperlink , it takes you to another sheet where data gets sorted with finance to show those 10 records.

Can this be done??? Bit Urgent

Thanks,
Mrinal

Not sure if this will help you, But I name a cell or cells on sheet 2 then on sheet 1 I create a hyperlink make sure you choose DOCUMENT. I hope I did not confuse you.

 

[mrinal saha]

Got Confused.. Could you pls throw some codes

 

[cummingsea]

Got Confused.. Could you pls throw some codes

I don't know now to explain it. But I created a screen recording, I could send to you via email if you wish or if you know of a web site to post it to so you can view it.

 

[mrinal saha]

mrinal_saha1@hotmail.com

mrinal (_) underscore than rest of it


thank you so very much