# Calculation Order using the Data from the other sheet Source.

• ### Question

• I have three sheets.

(1) Inventory Sheet
ITEM  2/2/15   2/3/15   2/4/15    2/5/15   2/6/15     2/7/15     2/8/15

Apple       2                         4                                         2              6

Pear                       3                         4                           2

(2) Order Sheet

ITEM  2/2/15   2/3/15   2/4/15    2/5/15   2/6/15     2/7/15     2/8/15

Apple       8                         6                                        8              4

Pear                         7                       5           1             8

(3) AVERAGE SALE Sheeet

ITEM  Average Sale

Apple       3.14

Pear         3.14

Those sheet has the head that is Date and Other data.

condition)
During One weeks (Mon through Sun),

AVERAGE SALE = (MONDAY OR FIRST INVENTORY(LAST WEEK DATA) + ORDER(LAST WEEK ORDER SUM) - LAST INVENTORY(LAST WEEK)/(LAST DATE - FIRST DATE +1)

Apple Sale = (2+ (8+6+8+4) - 6)/7(or Specific Term) = 3.14

Pear = (3+(7+5+1+8)-2)/7(or Specific Term) = 3.14

How can I program this formula by VBA.

Friday, February 27, 2015 4:09 AM