+ Reply to Thread
Results 1 to 6 of 6

Add snipped to paste report in descending order

  1. #1
    Registered User
    Join Date
    10-14-2017
    Location
    Miami, Florida
    MS-Off Ver
    2016
    Posts
    78

    Add snipped to paste report in descending order

    Hi,

    I have a code that extract matched rows and copy to another sheet, But it copy on next empty rows But is copying on Ascending Order (bottom of last records).

    I would like to make the change the copy/paste in descending order ( on top of last records)

    The snniped that i need to add in the code is
    Please Login or Register  to view this content.
    This is the original threat:
    https://www.excelforum.com/excel-pro...e-matches.html

    and this is the original code
    Please Login or Register  to view this content.



    Thank you!!

    Andy

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    5,337

    Re: Add snipped to paste report in descending order

    Hi Andy, played around with your code
    Please Login or Register  to view this content.
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you ( It doesn't hurt )

  3. #3
    Registered User
    Join Date
    10-14-2017
    Location
    Miami, Florida
    MS-Off Ver
    2016
    Posts
    78

    Re: Add snipped to paste report in descending order

    Hi KebellaH,

    Sorry to bother, but The Code is replacing previous Data, also is copying the header in "Test" tab on last row 1048576
    What I need is to Copy on Top (Above of previous) Data and so on...

    I realized that the matched numbers are pasting not in the same way, so I added a column with a Date in order to sort from.

    Note: please i upload the latest sample wb with the code and the way it's displaying the output.


    Thank you So much!!

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    5,337

    Re: Add snipped to paste report in descending order

    Hi Andy, will look at your file

  5. #5
    Registered User
    Join Date
    10-14-2017
    Location
    Miami, Florida
    MS-Off Ver
    2016
    Posts
    78

    Re: Add snipped to paste report in descending order

    Thanks Kebellah !!

  6. #6
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    5,337

    Re: Add snipped to paste report in descending order

    Hope Treat 4 does the trick.
    The target sheet is the worksheet named Keebellah check it before running the macro so you see what it is now, then got back to the data sheet and press Treat 4
    Bed-time here
    Good night

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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