[JenJo]

Hi all,

I'm trying to auto fill a row with data from another area within my
worksheet based on a drop down menu. The menu is all text, no numerical
values. Based on what a user selects from the drop down menu (7 options) the
next 4 columns in the same row will pull data (7 options) from another area.
Is there a way to do this and if so, how?

Thanks so much!

[Gord Dibben]

See Debra Dalgleish's site for working with VLOOKUP tables.


Gord Dibben MS Excel MVP

On Wed, 4 Jun 2008 12:34:32 -0700, JenJo
wrote:

Hi all,

I'm trying to auto fill a row with data from another area within my
worksheet based on a drop down menu. The menu is all text, no numerical
values. Based on what a user selects from the drop down menu (7 options) the
next 4 columns in the same row will pull data (7 options) from another area.
Is there a way to do this and if so, how?

Thanks so much!