Creating a Check/Guestlist

Hi guys,

What I would like is to have a list of names in column 1 and a some checkboxes in column 2. When I check one of these boxes I'd like the row I've checked to vanish and for the name to be copied into a separate sheet (to indicate that they have paid)

So far I have this code but it's sloppy and doesn't quite work as the checkbox doesn't hide and I haven't figured out how to copy the name over

Please Login or Register  to view this content.

Hi mooface. I've always found working with check boxes a little awkward. Instead of check boxes, would a drop down list in column 2 where you could choose "Paid" or "Unpaid" work for you?

Hi ya,

Yeah I am starting to consider that option. The idea was for this to be functional on a Tablet/touch screen environment so I thought a check box to be the easiest, but I suppose running a drop-down list could work out... I would still need some kind of active macro to hide the rows and copy the name over to a PAID sheet, any ideas?

Originally Posted by Mumps1

Hi mooface. I've always found working with check boxes a little awkward. Instead of check boxes, would a drop down list in column 2 where you could choose "Paid" or "Unpaid" work for you?

Hi again. Try the attached file. I've just entered some generic data to use as a test. The drop down list in column B goes down to row 20. If you have more names, you just have to copy the validation list down column B as far as you need it. When you choose "Paid" from the list the corresponding name will be copied to sheet "Paid". I have also included a button that will show all your names if they are hidden.

My apologies mooface. I found a little glitch. Please use this attachment.

that's amazing thank you!!

Let's try one more time.