ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Delete row if column criteria was met (https://www.excelbanter.com/excel-programming/360770-delete-row-if-column-criteria-met.html)

EKB

Delete row if column criteria was met
 
Hi to all,

I want to thank Ron de Bruin for giving me the links that solve my
problem on multiple worksheet merging.
I really appreciate it.

I hope that the group can help me build a macro again in my new
problem.
My worksheet now contains data which has a variable range, meaning I do
not know what will be the last row of data. I plan to use to use on
other worksheets.
The plan is to delete an entire row if column L and column N is blank
and the formula result in column T is 0 (zero). The criteria must be
satisfied before the entire row can be deleted.
Thanks again...


Ron de Bruin

Delete row if column criteria was met
 
Hi EKB

See this page
http://www.rondebruin.nl/delete.htm

If you need more help post back



--
Regards Ron de Bruin
http://www.rondebruin.nl


"EKB" wrote in message oups.com...
Hi to all,

I want to thank Ron de Bruin for giving me the links that solve my
problem on multiple worksheet merging.
I really appreciate it.

I hope that the group can help me build a macro again in my new
problem.
My worksheet now contains data which has a variable range, meaning I do
not know what will be the last row of data. I plan to use to use on
other worksheets.
The plan is to delete an entire row if column L and column N is blank
and the formula result in column T is 0 (zero). The criteria must be
satisfied before the entire row can be deleted.
Thanks again...





All times are GMT +1. The time now is 08:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com