+ Reply to Thread
Results 1 to 2 of 2

Auto-filling from database

  1. #1
    Registered User
    Join Date
    United States
    MS-Off Ver
    Excel 2007

    Question Auto-filling from database


    I am sorry if this is a newbie question. I am trying to design a macro that will fill out a form by finding the information in another sheet. Right now, each row has an inventory number assigned to it and in a perfect world I would like to enter the inventory number in a given box on sheet two, start the macro, find the rest of the information on sheet one and fill the other information such as serial number, model number and the such back on sheet two.

    So far, I have been able to get the macro to fill in the information, but the missing link seems to be actually finding the right row to get the information from. It keeps copying the information from the same row, no matter what inventory number I but in the box.


  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    MS-Off Ver
    Office 2010

    Re: Auto-filling from database

    We need to see your code. Or even better upload a sample sheet with a couple dozen entries.

    Be sure to use the Code tags if you post the code.(Icon looks like the hash mark.)
    (*) Reputation points appreciated.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread


Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1