Data entry in two stages onto the same sheet

[excel_user_1966]

I have a spreadsheet with these headings: Name, Tutor, Date, ServingDate, Signee. All the data my users enter goes under these.

The first three columns (Name, Tutor, Date) all need to be filled in by one person - hence my trusty user form.

However, the last two columns (ServingDate and signee), need to be completed by a different person some time later.

Now, my question is, if i have what looks like this as my spreadsheet:

Name/Tutor/Date/ServingDate/Signee
Sarah/12HN/14th/19th/Jules
Anne/14/16th/19th/Valary
Peter/12/2nd/7th/Jacob


... how do I get it so that the last two colums of ServingDate and Signee can be filled in by someone pressing a button to enter data so a user form comes up, and then this goes into the rows (i.e. along side the name they want to enter data for) they want?

I just read this back and i'm not sure if i've made it all clear enough, I hope I have.

 

[Duane]

You're making sense.

- When you make your list of names, say down column b, run numbers down column a (so the first name in b1 will have 1 in a1; the 2nd name in b2 will have 2 in a2, etc...)
- when you create your drop down list box, put the output cell in c1.
- now, when you select a name in your drop down list, the corresponding number will show up in c1.
- you can use a vlookup elsewhere in your sheet to vlookup(c1,$a$1:$B$100,2,false); it will look at the number in c1, look for it in a1:b100, and when it finds it, will go over to "column 2" which in this case is b, and return the data that's there.

Let me know if you need any clarification.