+ Reply to Thread
Results 1 to 3 of 3

Procuct Summary

Hybrid View

  1. 08-13-2010, 07:41 PM #1
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Procuct Summary

    Please refer to attach sheet ...
    Sheet Jul10 list the quantity order for our business.
    Column B : Qty Received
    Column D : Item #
    Column I : Date of Delivery

    In "Product Summary" sheet:

    I need a macro to accomplish following:

    I need Quantity received from Jul10 sheet summarized in "Product Summary" based on Item #
    listed in Row 3 ..Basically match the item # and add quantity in proper cell.

    I have completed manually for 7/5/2010 as you can see on Row 8 of "Product Summary" Sheet.

    Please let me know if you have any further questions..

    Thank you in advance for your help.

    Riz
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-13-2010, 11:39 PM #2
    stanleydgromjr
    stanleydgromjr is offline
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: Procuct Summary

    rizmomin,

    Detach/open workbook Index Match If - rizmomin - EF741506 - SDG14.xls.

    The formula in cell B4, confirmed with CTRL + SHIFT + ENTER :

    =IF(ISNA(INDEX(Jul10!$B$1:$B$5000,MATCH(1,IF(Jul10!$D$1:$D$5000=B$3,IF(Jul10!$I$1:$I$5000=$A4,1)),0))),"",INDEX(Jul10!$B$1:$B$5000,MATCH(1,IF(Jul10!$D$1:$D$5000=B$3,IF(Jul10!$I$1:$I$5000=$A4,1)),0)))

    Then copied across to cell R4.

    Then copy range B4:R4 down.
    Attached Files Attached Files
    Have a great day,
    Stan

    Windows 10, Excel 2007, on a PC.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
    Reply With QuoteRegister To Reply
  3. 08-13-2010, 11:56 PM #3
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: Procuct Summary

    Thank you so much.....this will work great for me...

    Riz Momin
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1