Hello,

Welcome to MOTH.

Hyperlinks let you jump to where it is linked to, it is not designed to work the way you describe. Anyway, you can read more about the HYPERLINK function here. If you want to show a value from sheet 2 in sheet 1, then it is no problem. There are different methods to do it based on if you want a dynamic or static reference. Do you have a sample file with some dummy data so please upload it and specify what you want to do.

Br,
Anders

Dear Anders,

Thank you for your quick response.  I have attached the excel form which can be of some help.

Thanks again,

ashley

Hi Ashley

You will need VBA for that.

Please refer attachment.

Hope this helps.

Sunny

Dear Sunny,

Thank you very much for helping me out as it was exactly what I was looking for.   I have another query in regards to this. I tried doing data validation in s1 but the pickup list does not appear in the application tab when I click the Sheet1 hyperlink.

Finally is there a possibility to print both information that is in sheet1 and sheet 2 at the same time?

I have reattached the excel with the amendment. 

Thank you again.

Ashley

Hi Ashley

Attached is the updated file.

Select S1 then hold the CTRL key and click on the S2 tab to group them.

You can now print them at the same time but on separate pages.

Sunny

Dear Sunny,

Thank you so much for your support. It works great.

Kind Regards,

Ashley