Hyperlink click "cell text" to next sheet and auto filter by the "same clicked text" VBA

Good evening,

is it possible to have a clicked text hyperlinked to next sheet and auto filter by the same text simultaneously using VBA?

example, "sheet1"click column B4 brings me to "sheet2 C:C C2 auto filter ", then appear "same result as sheet 1 B4"



thank you for the help~

Try this code in module1

Please Login or Register  to view this content.

And this code in sheet "1"

Please Login or Register  to view this content.

When you enter an Item Code in column B in sheet "1", it will create a hyperlink to Sheet "2" and filter on the entered item number.

Is that what you wanted?

Originally Posted by Croweater

Try this code in module1

Please Login or Register  to view this content.

And this code in sheet "1"

Please Login or Register  to view this content.

When you enter an Item Code in column B in sheet "1", it will create a hyperlink to Sheet "2" and filter on the entered item number.

Is that what you wanted?

Hi Croweater,

I will have multiple items in row B in "sheet 1",

i putted codes into designated place and come up with error , unkown name "filter"

I re-uploaded the xlsm file onto the first post, please assist,

thank you very much.

Look at the code in your sheet.

Please Login or Register  to view this content.

Can you see how this is different to what I put up?

Hint: Remove the first line.



You may also want to try this modification in Sheet1. Not sure how you want it to work.

Please Login or Register  to view this content.