Forum Discussion
Creating a interactive sign up list in ONE cell
I am creating a spreadsheet of events. Each event has it's details in their own row. I would like to have the last cell of each event row to be where several people can sign up to be at the event.
Example:
Date Event Who will be attending
12.1.24 Birthday (This is the cell I want several folks to be able to click on and enter their names into this one call)
Ideally, the document would have several events. Thank you for your help.
A drop down really won't work this way. You could back it up with a macro but a) macros (VBA) are not supported in excel online and a number of other formats and blocked by default on most computers, and b) if you are going to use VBA I would go with a custom form or something anyway.
Alternatively, you can use a script and link that script to a button that will work in excel online and desktop and such. That script can add the login name to the cell but that will be based on whose account is logged in on the computer, which may or may not be the actual person/email/info you want captured. Another option with a script is to add a cell they can edit to enter their name and then the button just appends that cell info to the list you want.
Another alternative if you have the list of all invitees is to list them in columns to the right and then add a drop down below each for status like 'no response yet', 'yes', 'no', 'maybe', etc... It would be hard to lock the sheet to prevent them from editting others but is that a big concern? if on sharepoint you can review changes to see who made what changes.
