J
Jennifer Carr
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!!!
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!!!