Hi everyone

I am trying to create a data entry form in excel, i am doing this on a worksheet rather than a user form as i want to use cascading lists which i cant for love nor money get to work on a user form. (without huge amounts of code that is beyond my skill level)

So this is what i have:


i have some named cells, for example, Name is cell B4 DOB is cell F6 and so on, what i am after is vba code i can assign to a command button that will:

1: copy each of the named cells (all in about 20) on sheet 1
2: Paste this to the next available row so if it was empty except headers A2 paste Name B2 paste DOB and so on along row 2
3: empty the values in the named cell on sheet 1 and basically reset the form.
All of this without leaving sheet 1

To add one further thing in, i have a few checkboxes so what do i need to do differently to get either the true or false value from the check box to paste into C2 on sheet2.

so the data in Sheet 2 would be Nick (A2) 16/01/82 (B2) True (C2)

Thanks All

Nick