Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Nov 2002
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Edit one person at a time

    Hi
    I have a list of people and scores in Excel(2000) eg:
    1 Tom 23 45 67 24 45
    2 Sue 56 43 25 76 87
    3 Bob 76 45 98 23 43
    On a new sheet I can arrange a combo box to call up one user and associated data - no problem
    BUT
    How can I edit that data and get it back to the first sheet?
    I can write in new scores beside the old ones but how do I get it back?

    Bob

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Edit one person at a time

    Have you tried using Data, Form. Highligh the columns of data and include one extra for your new scores, And goto Data, Form.

    There any changes you make to any record will be updated in your sheet. Just be careful that before moving to the next record you are happy that the information is correct. You can click restore to get record back to the way it was. That only works on the current record and only before moving to a different record.

    If you only make a small number of changes and change your mind the undo button might work.

    I think any other approach would require VBA.

    Andrew

  3. #3
    Lounger
    Join Date
    Nov 2002
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Edit one person at a time

    I hadn't used forms before, yep that'll do it. Thanks for that - so simple when you know what you're doing
    The only small problemis that the default form is a bit ugly. Is it possible to design your own that does the same thing?

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Edit one person at a time

    Yes, the data Form leaves a little bit to be disied, especially on data with many fields.

    The best solution is a custom form driven by VBA, which can be done.

    Andrew

Posting Permissions

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