Forum Discussion
Excel - Data Entry Form with dropdown boxes for easy data entering
Good afternoon
Excel - I hope somebody can help me please. I am creating a form for easy data entry as we have to inspect a property with 300 apartments in which all elements "lighting/extractor fan/ light switch" etc need to be categorised into "good/Fair/Needs Replacement/freetype some info" I can get the Excel Form done, but cannot get the dropdown to work. Please help me. I am working on Office 365 version 2210 and have attached a spreadsheet sample.
Help will be greatly appreciated.
Apie1975 Former Excel MVP John Walkenbach created a nice add-in for this: the J-Walk Enhanced Data Form. It is not available from the original site anymore, but I have attached it in a zip file. There is a text file with instructions in the zip file.
- Thank you so much, I have just downloaded this - I am super excited will try to do this tonight.
