Copy filtered data to another sheet using VBA

by

Best way of doing it

Below code is to copy the visible data in DBExtract sheet, and paste it into duplicateRecords sheet, with only filtered values. Range selected by me is the maximum range that can be occupied by my data. You can change it as per your need. 

  Sub selectVisibleRange()

    Dim DbExtract, DuplicateRecords As Worksheet
    Set DbExtract = ThisWorkbook.Sheets("Export Worksheet")
    Set DuplicateRecords = ThisWorkbook.Sheets("DuplicateRecords")

    DbExtract.Range("A1:BF9999").SpecialCells(xlCellTypeVisible).Copy
    DuplicateRecords.Cells(1, 1).PasteSpecial


    End Sub

More Related Contents:

  1. Excel matching based on name date and copying data to another sheet
  2. How to filter listbox values based on a Textbox value
  3. Loop through files in a folder using VBA?
  4. How can Excel VBA open file using default application
  5. Run same excel macro on multiple excel files
  6. how to detect whether VBA excel found something?
  7. VBA : save a file with UTF-8 without BOM
  8. Excel tab sheet names vs. Visual Basic sheet names
  9. Saving a Excel File into .txt format without quotes
  10. Excel VBA “Method ‘Document’ of object ‘IWebBrowser2’ failed”
  11. Determine if cell contains data validation
  12. VBA – Range to jpg picture
  13. Combine multiple Excel workbooks into a single workbook
  14. Sheet protection: UserInterFaceOnly gone
  15. VBScript – How to make program wait until process has finished?
  16. Making VBA Form TextBox accept Numbers only (including +, – and .)
  17. VBA Convert date to week number
  18. Inserting an Online Picture to Excel with VBA
  19. Change length of For loop while in the loop
  20. VBA – Run Time Error 1004 ‘Application Defined or Object Defined Error’
  21. Consolidating worksheets into one
  22. vba paste not working
  23. Can Advanced Filter criteria be in the VBA rather than a range?
  24. In Excel VBA, what is the way to check if the web page is fully loaded?
  25. Excel Useform: How to hide application but have icon in the taskbar
  26. Reading Web Pages using Excel VBA
  27. Excel VBA: auto click and open file from website
  28. How to have vba execute every 10 minutes?
  29. Read and write from/to registry in VBA
  30. Unable to read data from a CSV using ADO due to the driver thinking I am working with integers/number and showing nulls instead of text

Leave a Comment