build unique list from data worksheet that updates based on data selection? Example incl..

I hope my subject line is accurate....

[example XLS file attached]

I'm having a tough time figuring out how to accomplish the following:

I have 2 worksheets. Once is a "Menu" of items from a "Data" list.

My goal is to:

- Make items in 'Menu' worksheet auto-populate with data for each unique 'item' from 'Data' worksheet, using the first instance as the default

- Then, Create a selection drop down (data validation?) based on the 'Choice' field in Data, which would update all fields in Menu to the selected choice.

Maybe looking at the example would make it clear....


Thanks for any help you can provide.

Thanks Ace... It doesn't seem to be working (the way I intended anyway)

I was expecting it would do the following:


- 'Menu' worksheet is populated with unique entries from the 'Data' worksheet (1 per ITEM ID used in 'Data').
Note: An 'entry' in this case would = the full data row from the 'Data' worksheet

- Now, a user could work within the 'Menu' worksheet and click on the 'Choice' field to see different options available for that ITEM ID.

- When users selects new 'Choice', it will update the row for the ITEM ID that that the user is interacting with on the 'Menu' worksheet, with the rest of the data from the 'Data' worksheet that corresponds to the 'Choice' selection the user made

- When the user is done making all the choices, they would manually save the resulting document as a PDF to store their choices & the corresponding data.

Does that make sense?

I think I see... maybe the issue is just not having the dropdown box appear on the "menu" based "choice" field.... how to make it a dropdown list?