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!