Hello Andy, why not to use a Pivot Table?

regards from Brazil
Marcelo

"Andy" escreveu:

I have an excel worksheet with a "shopping list" The user puts in a number in
the quantity and it automatically updates the total. There are some instances
where there will be a 0 (zero) in there. I need to make a seperate master
sheet, where if the user has put in a value for a quantity then it will show
up with the name, price and which quarter they ordered it in on the seperate
worksheet.