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