![]() |
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... |
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