+ Reply to Thread
Results 1 to 3 of 3

Excel 2010 Formula for Moving Data

  1. #1
    Registered User
    Join Date
    10-28-2014
    Location
    California, USA
    MS-Off Ver
    2010
    Posts
    16

    Question Excel 2010 Formula for Moving Data

    Template_1105.xlsx

    1. I need Help trying to move the Bulk orders of the cookies over to the 1k pack size, while keeping in mind, they have to match the code/date and add to the numbers in the same row's orders.
    ex:For the first bulk amount on 1/1/2014; it is showing 5 orders, so I need to move the 5 orders over to the 1k orders and add them together (5+15), the total combined amount going in the 1k order cell (=20). The Date(1/1/2014) has to match as well as the code, the materials don't matter in this part

    2. I also need to move the Ready Stages orders and add them to the processing stage's orders while keeping the same pack size/code/date all the same.
    ex: This next part is moving(adding) the "order"(order column) amounts of the "ready stages"(stage column) over to the "Processing stage"(stage column) (have to share same date/code type/Pack size)

    This is for a large amount of data that would take too long to do by hand. I would appreciate any help to make the process faster, Thanks!

    P.S The bulk orders are counted in thousands (1k) but still have no pack size.
    Last edited by blue84rain; 11-05-2014 at 07:46 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: Need Help With Formula...

    Thanks for the title change

    Im a littke unsure exactly what you are trying to do here Perhaps if you provided a few sample answers, and explained how you got them, it would be easier to understand,

    Dony forget, you know exactly what you are dealing with, and what you want, we dont
    Last edited by FDibbins; 11-05-2014 at 04:35 PM.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    10-28-2014
    Location
    California, USA
    MS-Off Ver
    2010
    Posts
    16

    Re: Need Help With Formula...

    Is the information still unclear? I would appreciate it if someone would help me figure this out, if anyone has any questions please feel free to ask!

+ 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. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  2. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

Tags for this Thread

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