data validation on multiple pages or hyperlink solution

[Leigh Ann]

I have a customer list on a worksheet. On another, I have the customer list
as a dropdown so you can select one from the list. Once one is selected, I
want another worksheet to activate the information for that customer (such as
a collections sheet w/ all customers, but only want to see info on that
customer). My question is: can I set up a validation that will select the
same customer when one is chosen on another page, or is there a way to do a
VLOOKUP in a hyperlink once a customer has been chose so that it links to
that particular customer on the collections sheet?

Any thoughts or ideas would be appreciated.

Leigh Ann

 

[Debra Dalgleish]

If a customer has been selected on Sheet1, the VLookup formulas on
Sheet2 could refer to that cell. For example:

=VLOOKUP(Sheet1!C4,CustData,3,0)

where customer data is stored in a range named CustData.

 

[Leigh Ann]

Thanks for the quick reply, Debra. Since my customer data page will change
every week, since it is collection information, is there a quick way to name
each customer range using the customer name - something like a mass range
naming formula that changes with each name? Leigh Ann

 

[Debra Dalgleish]

You could use a dynamic formula to name the range. It will expand or
contract automatically as the data changes. There are instructions here:

http://www.contextures.com/xlNames01.html