AutoFill Cell w/ data from different sheet after action

**ngay528** · 06-22-2009, 06:22 PM

I have an excel file that contains two sheets. Sheet2 contains rows of different types of products with each of the columns containing details about the product.

On Sheet1, I have setup a data validation list in which a certain cell contains a drop down box that selects a product from the first column of all the rows on t from Sheet2. I used

Please Login or Register  to view this content.

When a list item is selected, I would like a function to be ran in which it autofills the columns to the right on this Sheet1 with the data from Sheet2 of the detailed information. I believe this can be done with vlookup but am having some difficulties with it returning N/A no matter what I choose.

Thanks

**jaslake** · 06-23-2009, 12:15 AM

I don't know for certain but I could probably help you figure this out. If you could attach a "dummied up" file (remove all personal info) with your current code, I'd be glad to look at it.

J

**ngay528** · 06-23-2009, 10:15 AM

Attached is a dummy file. Also would like to know how to make the list dynamic so as items on sheet 2 are added, the drop down will include these new items, and not any blank spaces (as there are now).

Thanks

**ngay528** · 06-23-2009, 10:58 AM

I have figured out my initial problem by using a vlookup. My problem was with misunderstanding vlookup properties and not knowing that they update after an action takes place. The code solved is in my dummy file.

And as long as 'ignore blanks' is checked under the function page, it will ignore all blanks after; so I just set my list array to go to a 1000 since my list won't get that big. (I thought it wasn't working when I changed it but after closing and re-opening the file, only the filled cells showed up in my drop down list.)