Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts

    Macro to extract data based on certain Criteria

    I have a spreadsheet where I need certain codes and values extracted based on certain criteria

    1) Where Code 765915 appears in Col G, I want the value extracted as well as the code above. However, If code 764100 is in the row directly above, then extract the code and value two rows above. for eg below extract 765915 25.79 and 767230 R 184.21


    767230 184.21
    764100 25
    765915 25.79


    2) Where code 765925 appears in Column G , multiply the value in the same row by 100/14 and extract code and values above this that equal the value multiplied by 100/14. The values codes the are in the rows above 765925 must be ignored i.e not to be extracted

    762301
    122210

    See Eg below

    765925 43708.33

    If multiplied by 100/14 = 312,202.36

    The following values if added up equate to this value and must be extracted

    763201 15559.56 Dr
    763710 15757.55 CR
    763720 4350 CR
    763550 877.19 Cr
    763610 4820.18 Cr
    763200 0
    763200 282807 CR
    763520 3200 Cr
    763510 15950 CR




    Your assistance in resolving this is most appreciated
    Attached Files Attached Files
    Last edited by HowardC; 2015-03-27 at 00:51.

  2. #2
    3 Star Lounger Supershoe's Avatar
    Join Date
    Apr 2014
    Location
    Austin, TX
    Posts
    252
    Thanks
    1
    Thanked 36 Times in 34 Posts
    What is this for?
    Don Guillett
    Excel Developer
    dguillett @gmail.com

  3. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    This post can be ignored as there are several variables that needs to be ignored. Too complex. Going to shelve this for the time being

Posting Permissions

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