+ Reply to Thread
Results 1 to 7 of 7

Filter and copy negative and positive amounts with rows to 2 other sheets

  1. #1
    Forum Contributor
    Join Date
    07-28-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010 at work excel 2016
    Posts
    1,102

    Filter and copy negative and positive amounts with rows to 2 other sheets

    HI I have below code I cant make work correctly. It should copy based on the amounts in column D.
    All positive amounts with row to sheet4 and all negative amounts with row to sheet 5.
    There is header in all sheets but have a look at the test sheet also.
    I cant figure out why its not working.

    Please have a look at below code and test sheet.

    Thanks in advance

    The code.
    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: Filter and copy negative and positive amounts with rows to 2 other sheets


    Hi,

    must use SpecialCells method to copy a filtered range …

    See in VBA inner help and in relative threads from this forum …

  3. #3
    Forum Contributor
    Join Date
    07-28-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010 at work excel 2016
    Posts
    1,102

    Re: Filter and copy negative and positive amounts with rows to 2 other sheets

    Hi Marc that's infact what I have tried to solve before I came here. And so far no luck with it. Please if you can provide an example or answer, so I can see how it is. I have tried search in relative threads in this forum and other places. So if you can please provide a code so I can see how it can be,
    Thanks

  4. #4
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Exclamation Re: Filter and copy negative and positive amounts with rows to 2 other sheets


    One of several threads found via a simple search here

  5. #5
    Forum Contributor
    Join Date
    07-28-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010 at work excel 2016
    Posts
    1,102

    Re: Filter and copy negative and positive amounts with rows to 2 other sheets

    Hi I just found out I made a bad mistake in this code. stupid infact. I forgot to change the autofilter field to 4 because I have changed the row. So its basically solved not thanks


    Please Login or Register  to view this content.

  6. #6
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Filter and copy negative and positive amounts with rows to 2 other sheets

    You're filtering on the wrong column if you want what's in Column D.

    Try:

    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    07-28-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010 at work excel 2016
    Posts
    1,102

    Re: Filter and copy negative and positive amounts with rows to 2 other sheets

    Hi John and thanks I think we passed each other, I suddenly realized this also which was not so clever I admit that hehe. But its solved and thanks allot for having a look at this,.

    Have a nice day

    Sincerely
    Abjac

+ 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: 6
    Last Post: 02-03-2014, 05:57 PM
  2. Zeroing out Positive and Negative Values in Rows
    By Lancer234 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-28-2013, 03:07 PM
  3. How to delete those rows which has same positive & negative value
    By joyharry in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 05-24-2013, 03:35 AM
  4. Convert negative to positive in sheet containing both positive/negative numbers
    By sa02000 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-29-2010, 07:52 PM
  5. [SOLVED] allocating between positive and negative amounts
    By THosier in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-07-2005, 10: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