hi community !
I want to show the details for all of sheets & calculation for all of values for each sheet .
so should show me messagebox based on sheets names and summing the values for each sheet into column E,G and calculation like this
SHEET NAME QTY TOTAL
FIRST 472.00 $ 5,676
PURCHASE 800.00 $ 9,656.00
SALES 182.00 $ 2,756.00
RSALES 15.00 $ 230.00
RPUR 10.00 $ 133.00
CALCULATION 1,479.00 $ 12,673.00
the calculation in messagebox
QTY= 472+800+182+15+10=1,479
TOTAL= $ 5,676+ $ 9,656.00-$ 2,756.00+ $ 230.00- $ 133.00= $ 12,673.00
thanks
I want to show the details for all of sheets & calculation for all of values for each sheet .
| s(2).xlsm | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 1 | ITEM | BR | TY | OR | QTY | PRICE | TOTAL | ||
| 2 | 1 | FR | APPLE | LL | 270.00 | 12.00 | $3,240.00 | ||
| 3 | 2 | FR | PEAR | NN | 60.00 | 11.00 | $660.00 | ||
| 4 | 3 | FR | BANANA | 70.00 | 12.00 | $840.00 | |||
| 5 | 5 | VEG | TOMATO | SS | 72.00 | 13.00 | $936.00 | ||
FIRST | |||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| G2:G5 | G2 | =E2*F2 |
| s(2).xlsm | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 1 | ITEM | BR | TY | OR | QTY | PRICE | TOTAL | ||
| 2 | 1 | FR | BANANA | TT | 300.00 | 12.00 | $3,600.00 | ||
| 3 | 2 | FR | APPLE | LL | 270.00 | 12.00 | $3,240.00 | ||
| 4 | 3 | FR | PEAR | NN | 60.00 | 11.00 | $660.00 | ||
| 5 | 4 | FR | BANANA | 70.00 | 12.00 | $840.00 | |||
| 6 | 5 | VEG | TOMATO | SS | 72.00 | 13.00 | $936.00 | ||
| 7 | 6 | VEG | TOMATO | AA | 22.00 | 14.00 | $308.00 | ||
| 8 | 7 | VEG | ONION | AA1 | 6.00 | 12.00 | $72.00 | ||
PURCHASE | |||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| G2:G8 | G2 | =E2*F2 |
| s(2).xlsm | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 1 | ITEM | BR | TY | OR | QTY | PRICE | TOTAL | ||
| 2 | 1 | FR | BANANA | TT | 120 | 15.00 | $1,800.00 | ||
| 3 | 2 | FR | APPLE | LL | 50 | 16.00 | $800.00 | ||
| 4 | 3 | FR | PEAR | NN | 12 | 13.00 | $156.00 | ||
SALES | |||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| G2:G4 | G2 | =E2*F2 |
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| G2:G3 | G2 | =E2*F2 |
| s(2).xlsm | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 1 | ITEM | BR | TY | OR | QTY | PRICE | TOTAL | ||
| 2 | 1 | VEG | TOMATO | SS | 5.00 | 13.00 | $65.00 | ||
| 3 | 2 | VEG | TOMATO | AA | 4.00 | 14.00 | $56.00 | ||
| 4 | 3 | VEG | ONION | AA1 | 1.00 | 12.00 | $12.00 | ||
RPUR | |||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| G2:G4 | G2 | =E2*F2 |
so should show me messagebox based on sheets names and summing the values for each sheet into column E,G and calculation like this
SHEET NAME QTY TOTAL
FIRST 472.00 $ 5,676
PURCHASE 800.00 $ 9,656.00
SALES 182.00 $ 2,756.00
RSALES 15.00 $ 230.00
RPUR 10.00 $ 133.00
CALCULATION 1,479.00 $ 12,673.00
the calculation in messagebox
QTY= 472+800+182+15+10=1,479
TOTAL= $ 5,676+ $ 9,656.00-$ 2,756.00+ $ 230.00- $ 133.00= $ 12,673.00
thanks
