Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Trying to get excel to auto fill a series of fields

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

    Default

    I have a database of customer names, addresses, citys and a field for customer notes. They are linked by individual customer numbers I have to find 40-50 customers per day and put them into a worksheet manually. I was wondering if there was a way for excel to fill in the customer fields based on their customer number. So if I enter a number in the cust ID field, that it will find that customer in the database and fill in the rest of the information for me. I have done this in file maker, rather quickly, but for some reason I am excel-dense.

    Thanks in advance

    Debi

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Christchurch New Zealand
    Posts
    1,030
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    you could use vlookup formulas or design some code if u can vba

Some videos you may like

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
  •