delete entire rows if… (2000)

Topic

New Reply

Messaggio cancellato da sal21

Reply | Quote

Replies

You can use autofilter and not have to create a macro.
In S3 (S is column outside the data range) enter the formula:

=I3J3

Copy it down the all the rows

In T3 (T is column outside the data range) enter

=and(I3j3,K3l3)

Copy it down the all the rows

Data- filter – autofilter on your range
For “Macro1” filter on column s, then delete the visible rows
For “Macro2” filter on column t, then delete the visible rows

Steve

Reply | Quote

You can use autofilter and not have to create a macro.
In S3 (S is column outside the data range) enter the formula:

=I3J3

Copy it down the all the rows

In T3 (T is column outside the data range) enter

=and(I3j3,K3l3)

Copy it down the all the rows

Data- filter – autofilter on your range
For “Macro1” filter on column s, then delete the visible rows
For “Macro2” filter on column t, then delete the visible rows

Steve

Reply | Quote