I'm trying to create a checklist that will, once completely filled in, add a name to a list. The process is as follows
when all points on the list are checked the spreadsheet will fill an entry in a new list with a name and reset the checks on the list
I leave the column to the right of the list entries blank. I fill it with a 1 when it is complete. At the bottom of the checklist there should be a cell which checks that none of the cells in the list are blank and, when none of them are blank, executes some sort of function. Is this possible? I want it to execute a function or macro to add a name (predefined at the top of the checklist) to a separate list of things completed. In this case I am installing software on computers so the checklist is to check that I've installed all the software and the name is the name of the computer, so I will have a list of all the computers I've installed this software on and also if I leave halfway through a job someone else can easily pick up where I left off because it is clear what I have and haven't installed.
So far I have tried using the IFBLANK function but that doesn't seem to be able to state FALSE when applied to a region of cells rather than just one cell.
Bookmarks