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

**workerb** · 11-10-2008, 10:40 AM

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!

**DonkeyOte** · 11-10-2008, 11:21 AM

Without knowing your data layout in terms of your "all data" sheet it's hard to comment... I would however say that first take a look at the following functions in XL Help:

VLOOKUP

INDEX & MATCH (separate functions but regularly used in conjunction with each other)

**workerb** · 11-10-2008, 11:48 AM

the data layout in my all-data tab is set up with the following columns:
customer name
customer address
customer city
customer state
customer zip
customer phone
etc.
it is an all-inclusive listing of all of the customers in question with their physical information.

on the form at the top left is their basic information:
cell A1 = customer name
cell A2 = customer phone
cell A3 = customer address, and so on..

but what i am wanting to do, is enter the line number from the all-data tab outside of the form and have the info from the all-data tab auto-populate on the form.
so say i enter "10" in cell K1 on the form sheet, it would pull all info from line number 10 from the all-data sheet...
hope this helps!
again, much thanks!

**shg** · 11-10-2008, 11:53 AM

workerb,

Welcome to the forum.

Please take a few minutes to read the Forum Rules about thread titles, and then edit yours to make it descriptive of your problem.

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

LinkBack

Thread Tools

Rate This Thread

Display

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

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions