Range with VBA

[Guest]

Hello,

I need help to design a VBA Formula that would sum up in column L all rows
in Column E with the text "paid" and delete the duplicate rows, but the range
to look for those rows has to be from Column E with the text "Cleared items"
to column E with the text "End of month"
Is this possible?
Jeff

 

[Guest]

no. as soon as you said "delete".
formulas return an value, they cannot perform an action
like delete a line.
you can do the sum.
Assume data to sum is in c2 to c20 then at c21 put
sumif(E2:E20,"Paid",C2:C20)

 

[Guest]

Hi,
Is it as least possible to get VBA formula for my range ?
Jeff

 

[Myrna Larson]

=IF(E2="paid",1,0)

Copy that formula down, then sort or AutoFilter on that column. If you sort,
those rows will be at the bottom, where you can delete them.

If you AutoFilter, just select the visible rows and delete them.