Need help with a complicated function

S

smokief

I don’t know if I need a macro or what for this one. I have a form (type)
spreadsheet (which I did not write) that has a lot of drop down boxes to
complete the form. For one of the questions, I would like the user to be
taken (hyperlink) to another sheet in the workbook. Further, when the user
answers the questions in this spreadsheet, the cell on the first worksheet is
populated by the result of the second worksheet. It would be OK to remove the
drop down box on this cell. Example:
•Cell G24 on Sheet1 hyperlinks to Sheet2
•The answers to questions on Sheet2 result in a yes/no answer
•Cell G24 on Sheet1 (or maybe an adjacent cell?) is populated with the
results (yes/no) from Sheet2
 
T

Tevuna

If the Yes/No on sheet2 is in cell A1, do this on sheet1 G24:
=Sheet2!A1
Insert > Hyperlink > Place in this document > Sheet2
 
S

smokief

Tevuna - This works beautifully. And to prevent users from overriding the
results, I protected that cell. Thank you very much for your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top