locked
Calculation Order using the Data from the other sheet Source. RRS feed

  • 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

Answers