Filtering with VBA
 

Hi,
I'm using Windows XP with Office 2003
I have a 2-worksheet workbook in Excel. 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
info from the second column:

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

Any help gratefully received
Yendorian