Vba macro to copy row from table if value in table meets condition

by

That is exactly what you do with an advanced filter. If it’s a one shot, you don’t even need a macro, it is available in the Data menu.

Sheets("Sheet1").Range("A1:D17").AdvancedFilter Action:=xlFilterCopy, _
    CriteriaRange:=Sheets("Sheet1").Range("G1:G2"), CopyToRange:=Range("A1:D1") _
    , Unique:=False

More Related Contents:

  1. What is the most efficient/quickest way to loop through rows in VBA (excel)?
  2. Change length of For loop while in the loop
  3. How do I get values from a hidden worksheet using VBA [closed]
  4. How to copy cells that contain certain text to another worksheet [closed]
  5. VBA Macro for copying and pasting columns on same excel sheet
  6. Excel VBA, code to count the # of filled cells, then find highest and 2nd highest and subtract the corresponding column #’s [closed]
  7. Levenshtein Distance in VBA [closed]
  8. VBA Runtime Error 1004 “Application-defined or Object-defined error” when Selecting Range
  9. How do I base64 encode a string efficiently using Excel VBA?
  10. Assign event handlers to controls on user form created dynamically in VBA
  11. Programmatic Access To Visual Basic Project Is Not Trusted
  12. Can I make this macro more efficient or faster?
  13. Conditional Formatting using Excel VBA code
  14. Controlling IE11 “Do you want to Open/Save” dialogue window buttons in VBA
  15. How to get the background color from a Conditional Formatting in Excel using VBA
  16. VBA Excel Populate ListBox with multiple columns
  17. How to “flatten” or “collapse” a 2D Excel table into 1D?
  18. VBA Macro to compare all cells of two Excel files
  19. What does ReDim Preserve do?
  20. Convert RTF (Rich Text Format) code into plain text in Excel
  21. lastrow and excel table.
  22. Open a workbook from VBA and disable Workbook_Open() code?
  23. Creating form programmatically in the module using vba
  24. How to filter listbox values based on a Textbox value
  25. Calling regasm without administrative rights for COM interop in Excel VBA
  26. Is there a way for DIR(path) in VBA to handle strings longer than 260?
  27. Start VBA macro when editing a cell
  28. VBA Run-time error 438 appears when “paste” runs
  29. If Not function proceeds when value *is* the one specified
  30. Copy an entire worksheet to a new worksheet in Excel 2010

Leave a Comment