Moving information to a different page

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hello Andy, why not to use a Pivot Table?

regards from Brazil
Marcelo

"Andy" escreveu:
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Moving Information 7
how to delete an excel line based on a condition 2
Is there a way to parse multiple values in a cell and applycalculations to those cell ? 1
Automatically Transfer Info from one worksheet to another 1
I would appreciate some help with a formula 3
Add/Subtract columns from tab to tab in same file 3
extact certain information from sheet 1 to shhet 2 columns e:e and 2
Sumproduct help 6

Back
Top