Hello,

I am not sure if this is even possible to do but i'm keeping my fingers crossed.

basically lets say I have data in row 1-5 and col A-D in one sheet1. In sheet2 I want to have a drop down list set up so that when select the item in the drop down list that corresponds to cell A1 in sheet 1, the other data that is in the remainder of the rows and columns would populate as well. Does that make sense?

So say in the drop down menu I have names, and in the table setup for the drop down list I would have the name, address, age etc. So when I select a name, I want to have the rest of the info corresponding to that name populate on its own.

Is this possible? I am not good with VBA so can this be done without using code? I was thinking of doing it with VLOOKUP but the problem i am having is that some of the names would be the same so the formula would not be able to tell the difference.

I am not a pro at excel, so there might be an easy way to do this or it might be complicated. I am not sure..

Any help it will be highly appreciated.

thanks.