Moving information to a different page

[Andy]

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.

[Marcelo]

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.

[Andy]

Basically as it stands it is:
Qty Quarter Qty Quarter Qty Total
Quarter Total
Chair 0 0 0 0 0
0

Table 0 0 0 0 0
0

The user changes the Qty and the Quarter Value changes which then changes
the Quarter Total. I need the information only if they put a 1 in the Qty. Is
there a formula for this?

"Marcelo" wrote:

> 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.