Results 1 to 2 of 2

Thread: macro to copy paste filtered data

  1. #1

    macro to copy paste filtered data



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Champs,

    I have a huge date with 5000 rows todays and may be more tomorow...
    the fields are code, id number and schedule number and error 1 to error 20.

    i need to filter the error column . say f and filter "Yes" and then copy the corresponding code number and ID number to output sheet (last row of the output sheet).
    like this i need to filter manually from f column till W column. please help me with a macro. i have attached a sample file.sample.xlsx

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,225
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Cross posted and solved here: http://www.excelforum.com/excel-prog...xcelhelpseeker, please have a read of this article: http://www.excelguru.ca/content.php?184
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training) or with my book M is for Data Monkey!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Posting Permissions

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