excel_user_1966
New Member
- Joined
- Mar 24, 2002
- Messages
- 7
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.
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.