Macro to copy rows based on a given criteria

Hi Guys,
I am trying to pull rows from a list based on the criteria if Date in Column D is less than Date in Column H i.e copy the entire row and paste in new sheet. Any help will be highly apprecited.

Thanks.
Roop

Hi Roop,

A sample would make it easier but...
I'd create a helper column on each row and set it = D1< H1 and copy it down. This will give you a long column of True or False.

Then I'd do a Advanced Filter of your data and filter in only True rows.

Without a sample file that might give you a method to do it yourself.