checklist which, upon completion, adds a name to a list

[daniel.szemeti]

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.

[pjwhitfield]

Can you upload a copy of your spreadsheet please?

[daniel.szemeti]

http www filedropper com/book1_6

[WideBoyDixon]

You need a macro to achieve what you're trying to do. Right click the sheet name and select "view code". Paste the following into the code window:

Please Login or Register  to view this content.

That will trigger copying the name in B1 to the end of the list in column D once all items are complete.

WBD

[daniel.szemeti]

Thanks, that's perfect!