G
Guest
Guest
I need to create a worksheet where
1) There is a question with a drop box where you select the answer
2) Can't do validation,etc because the list must not be seen on the worksheet.Could hide it but then I would need to protect the worksheet
3) Can I then add an if operation based on the selection made on the drop box to award numerical points to answers?
HELP
1) There is a question with a drop box where you select the answer
2) Can't do validation,etc because the list must not be seen on the worksheet.Could hide it but then I would need to protect the worksheet
3) Can I then add an if operation based on the selection made on the drop box to award numerical points to answers?
HELP