Prev: E-mail excel attachment via Lotus Notes
Next: Question on Form Textboxes
From: mahendra2210 on 12 Jan 2010 12:30
"I have a distribution list of 5 cities in cell A1, 5 manufacturers in cell
B1, 5 products category in cell C1, and 5 product list in cell D1."

Now, I want that if I select one particular city in cell A1, then it should
give me options to select manufacturers available in that city only.

Again, when I select one particular manufacturer in cell B1, then in cell C1
it just show me product category produced by that particular manufacturer.

Then, continuing from previous step I select one product category from that
list (cell C1) and then it should give me products list under that category
in Cell D1.

Now, finally selecting an item from the product list in Cell D1, it should
pop up the username in Cell E1.

Now, as far as this username is concerned I know their combination......

So, what I want is that.... when particular city, manufacturer, category and
product is selected it gives me username in cell E1.

From: JLGWhiz on 12 Jan 2010 12:47
Multiple posting does not increase the odds of getting results.


"mahendra2210" <mahendra2210(a)discussions.microsoft.com> wrote in message
news:8732C744-F4C6-4A89-905E-8EE2239E1D6F(a)microsoft.com...
> "I have a distribution list of 5 cities in cell A1, 5 manufacturers in
> cell
> B1, 5 products category in cell C1, and 5 product list in cell D1."
>
> Now, I want that if I select one particular city in cell A1, then it
> should
> give me options to select manufacturers available in that city only.
>
> Again, when I select one particular manufacturer in cell B1, then in cell
> C1
> it just show me product category produced by that particular manufacturer.
>
> Then, continuing from previous step I select one product category from
> that
> list (cell C1) and then it should give me products list under that
> category
> in Cell D1.
>
> Now, finally selecting an item from the product list in Cell D1, it should
> pop up the username in Cell E1.
>
> Now, as far as this username is concerned I know their combination......
>
> So, what I want is that.... when particular city, manufacturer, category
> and
> product is selected it gives me username in cell E1.
>


From: jimthompson5802 on 12 Jan 2010 14:31

Look @ Hack #25 "Create Validation Lists That Change Based on a Selection
from Another List" in the book "Excel Hacks, 2nd Ed." by D. & R. Hawley
 | 
Pages: 1
Prev: E-mail excel attachment via Lotus Notes
Next: Question on Form Textboxes