+ Reply to Thread
Results 1 to 18 of 18

Auto fill consecutive row after processing from different sheet.

Hybrid View

  1. #1
    Registered User
    Join Date
    12-29-2010
    Location
    Indonesia
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Auto fill consecutive row after processing from different sheet.

    Hello..
    Here's a comparison for the result.
    exclpic.xls is the temporary result.
    wiw.xls is the result I want.

    I hope you notice the differences:
    1. The dates are in ascending order, no matter where it takes. Either from "Buy" or "Sell", they're put in ascending order.
    2. If there more than 1 inputs on the same date, either "Buy" or "Sell", the data will be put in different rows. ie: row 4 and 5 (26 Mar). row 9 and 10 (29 Mar).
    3 And most importantly, there are no Input and Output in the same row. In C2, the total 74.625.500 which is from "Buy" went to Ouput.
    The same total from "Buy". All went to Output. (C4, C5, C6, C7, C8).
    4. For the Input, 75.600.000 in B3 is from "Sell". Please notice the right side of B3 is empty, as the left side of C2 is empty. It's because Input means profit which we got from "Selling", whilst Output means "Buying" the products.

    Sorry to confuse you with my language.
    Attached Images Attached Images
    Last edited by ganekon; 01-04-2011 at 11:30 AM.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1