View Single Post
  #1   Report Post  
Jennifer Carr
 
Posts: n/a
Default Should be an easy one for you Gurus...

Okay,
I'm making a Sales quotation sheet:
In it I have a database of customer addresses in columns like this:
Column A Column B Column C...
Company Address City State Zip So on...

I want to be able to select a company in one cell (I've already created a
list in Data Validation) and have the address, city, state, etc come up
below like this:

Company Name (select this cell)
Address
City, St Zip
Phone
Fax

So in sum:
Select one cell, the cells below fill in automatically the address info
from the database columns.
Make sense?
Thanks everyone!!!