Filtering in VBA

[Yendorian]

I have a 2-worksheet workbook. Sheet 1 contains a dropdown list of items for
selection. Sheet 2 contains a spreadsheet with 3 columns of percentages and 7
rows of ingredients. Some of the cells are blanks.
I need to select an item from the drop down list (sheet 1), tie it in with
the relevant column (sheet 2), then print the name of the item with a list of
the ingredients and percentages on sheet 1 again (rather like a recipe). The
following might help (don't try the recipe - it won't work!!!!):
Ingredients Cake Bun Scone
Butter 20% - 15%
Margarine - 20% -
SR flour 60% - 55%
Salt 3% - 3%
Egg 10% 10% 17%
Water 7% 10% 10%
Plain flour - 60% -.

Here, if I select 'Bun' from the drop down list, I should get the following:

Margarine 20%
Egg 10%
Water 10%
Plain flour 60%

Any help gratefully received
Yendorian

 

[Eric Legault [MVP - Outlook]]

I think you want one of the Excel newsgroups down the hall!

--
Eric Legault [MVP - Outlook]
MCDBA, MCTS (Messaging & Collaboration, SharePoint Infrastructure, MOSS 2007
& WSS 3.0 Application Development)
President
Collaborative Innovations
-> Try Picture Attachments Wizard 2.0 For Microsoft Outlook <-
-> Take your SharePoint content offline <-
-> More info: http://www.collaborativeinnovations.ca <-
Blog: http://blogs.officezealot.com/legault