ExcelBanter - View Single Post

Bob Phillips

"Few more questions" <Few more wrote in
message ...

Those sites were very helpful, except I found out that you can not do data
validation to a different worksheet. That leads to a couple more
problems,
which I'm not sure how to fix.

Yes you can, but you have to be a little circuitous.

The range on the sheet being referred to should be given a defined name
(InsertNameDefine...) and use that name in DV

1. We are going to be sorting by company name, then having the contact
and
address, etc. come up once the company name is typed in. Unfortunately,
we
have multiple contacts at some companies, so is there a way to do the
vlookup
and have a choice of which contact name to use if the company name is the
same (I tried it the way I thought would be correct, and the results were
quite underwhelming).

That is tricky. You would need VBA to determine that there are many and
present a list to the user to select from, or maybe list them in the
worknook and get the user to put a checkmark alongside it. Doable, but not
VERY simple.

2. Is there a way to have the Company name AutoFill as you are typing?
For
example, if i typed "McD" then McDonalds would autofill (presuming we only
had one contact there)

Not with Data Validation, for that you need a combobox.