Dropdown List Question

[ctsuhako]

Hello:
I have three dropdown lists that are populated from a different worksheet. They work without an issues. What I would like to do next is a little more complicated for me. Let's say the dropdowns are "Style (A2)", "Color (B2)", and "Size (C2)". Upon selection of each dropdown, I am populating cell F2 with the selection from A2 (=A2), cell G2 with the selection from B2 (=B2) and cell H2 with the selection from C2 (=C2). What I would like to do after that is have the next selections from cells A2,B2 and C2 populate the next cells down (i.e., F3,G3 and H3) and I would like this to continue as long as the user keeps making selections. Is this possible? Thank you!

 

[Andrew Poulsom]

Yes, but you will need to use macros rather than linked cells. Where are your dropdowns from - Control Toolbox or Forms Toolbar?

 

[ctsuhako]

Hello, Andrew:

The dropdowns were created using Data Validation.

Thanks!

Clay

 

[Andrew Poulsom]

So how are you populating the other cells?

 

[ctsuhako]

I am populating the other cells by using =A2, =B2, etc.

Clay

 

[Andrew Poulsom]

Sorry, it's not possible with formulas.

 

[ctsuhako]

Thank you. Is it possible using a different method?