Need help with a complicated function
 

I dont 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

Need help with a complicated function
 

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


"smokief" wrote:

I dont 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

Need help with a complicated function
 

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

"Tevuna" wrote:

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


"smokief" wrote:

I dont 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