Data entry in two stages onto the same sheet
Find bottlenecks in your Excel workbooks
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Data entry in two stages onto the same sheet

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Data entry in two stages onto the same sheet

     
    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.

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Fort McMurray, AB
    Posts
    218
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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.
    Regards, Duane
    Office2010 in Win7

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com