How to looping through data and copy to new sheet if condition is met in VBA

[XcelNoobster]

So I have an excel sheet called Data that has up to Column I. My data start on row 4. I want to loop through all n rows and copy all the data, but don't copy the row where Column G is empty AND Column H is 0. How would the macro look like? I know the logic, but the syntax is very confusing for me.

 

[Joe4]

Welcome to the Board!

How about just using an Advanced Filter to filter the records you want and copy to a new location?
Here is a link that shows you how to do that: How to copy data to another worksheet with Advanced Filter in Excel?

If you really want VBA, here is a link that shows you how you can filter and copy just the visible rows via VBA code:

How to Autofilter and Copy Visible Rows with Excel VBA - ExcelDemy

n this tutorial, I’ll demonstrate 3 methods to autofilter and then copy the filtered visible rows in Excel VBA with proper explanation.

www.exceldemy.com