Log In
Register
Home
Active Member
November 2, 2021
Offline
HI,
I have an excel workbook with 2 sheets. Sheet1 and Sheet2. I want to stay on sheet1 and create a hyperlink to sheet2 but I want the information that is available in sheet2 to be displayed in sheet1 itself once I click the link... how can I do this?
See Answer
VIP
Trusted Members
December 7, 2016
Offline
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
Active Member
November 2, 2021
Offline
Dear Anders,
Thank you for your quick response. I have attached the excel form which can be of some help.
Thanks again,
ashley
VIP
Trusted Members
June 25, 2016
Offline
Hi Ashley
You will need VBA for that.
Please refer attachment.
Hope this helps.
Sunny
Active Member
November 2, 2021
Offline
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
VIP
Trusted Members
June 25, 2016
Offline
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
Answers Post
1 Guest(s)
