+ Reply to Thread
Results 1 to 3 of 3

pending order calculation

  1. #1
    Forum Contributor
    Join Date
    02-14-2010
    Location
    oman
    MS-Off Ver
    Excel 2003
    Posts
    384

    Post pending order calculation

    Here i have attached my sample sheet & this report generating by our system.. in this excel sheet first sheet is normal data & second sheet is my requesting data. i need a macro to do bellow things..

    01. need to inset one column after column "J" (Qty). so it will be column "K".

    02.add "Pend Ord" text to K2 cell.

    03.Column "D" to "I" row data need match with same columns above. if something match, that matching all the rows column "J" values need to sum & display in same row column "K".( my English is very bad so it's really difficult to explain. so pls check my sample u can understand what i want to say.)

    ex-
    my sample sheet K4 cell is empty because there is no matching data rows above.
    my sample sheet K8 cell is 40 because there are one matching data rows above & that row column "J" value is 40.
    my sample sheet K9 cell is 100 because there are two matching data rows above & that rows column "J" values are 40+60


    pls make macro for this..thanks in advance..
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    02-14-2010
    Location
    oman
    MS-Off Ver
    Excel 2003
    Posts
    384

    Unhappy Re: pending order calculation

    Pls help me friends.

  3. #3
    Forum Contributor
    Join Date
    02-14-2010
    Location
    oman
    MS-Off Ver
    Excel 2003
    Posts
    384

    Re: pending order calculation

    Pls give me at least formula.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Volatile - Calculation Order
    By Zalambur in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-05-2011, 11:35 PM
  2. Order of calculation
    By Louise in forum Excel General
    Replies: 12
    Last Post: 06-02-2006, 03:55 AM
  3. [SOLVED] Order of calculation
    By RW in forum Excel General
    Replies: 3
    Last Post: 01-10-2006, 10:15 AM
  4. [SOLVED] SQL.REQUEST Calculation Order
    By Ryan Smith in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-08-2005, 10:06 PM
  5. Order of Calculation
    By John H W in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-07-2005, 08:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1