Results 1 to 4 of 4

entering line number from all-data sheet that will autopopulate info into a form

Threaded View

  1. #1
    Registered User
    Join Date
    11-10-2008
    Location
    st. louis, MO
    Posts
    2

    Question entering line number from all-data sheet that will autopopulate info into a form

    hello!
    i am in need of help with some kind of formula, i hope there is a way to even do this.
    here's the situation:
    say on the 1st excel sheet cells A2-A5 list one customer's name, address, etc. along with their specific customer needs. this is a generic form that can be updated with different customer's info.
    on the 2nd sheet is a spreadsheet with every customer's name, address, etc.
    here's what i want to do:
    use a cell outside of the specific customer form, say K1, and enter the line from the all-data sheet for the customer's info I want to input into the main form. so say on the all-data sheet customer number 11 is Joe's Business.
    In cell K1 on the form, I can put 11 and Joe's Business information will auto-input into the form..
    Does anyone know if this is possible?
    Thanks in advance for you assistance!
    Last edited by workerb; 11-10-2008 at 12:00 PM. Reason: non-descriptive title

Thread Information

Users Browsing this Thread

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

Bookmarks

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