Deleting row with specific value
Could some kind soul please advise syntex (macro)for deleting a row if first
3 character of a cell contains "FST" I have some value in column "H" which contains value FST,FST1,FST2 and so on. What i want to do is that if first 3 chracters in column "H" has a value "FST" then i want to delete that row. Thanks in advance Regards Jed |
Deleting row with specific value
try sorting and then deleting. Record a macro if desired.
-- Don Guillett SalesAid Software "Jed" wrote in message ... Could some kind soul please advise syntex (macro)for deleting a row if first 3 character of a cell contains "FST" I have some value in column "H" which contains value FST,FST1,FST2 and so on. What i want to do is that if first 3 chracters in column "H" has a value "FST" then i want to delete that row. Thanks in advance Regards Jed |
Deleting row with specific value
Hi Jed,
I don't think you need code. Use AutoFilter and choose Custom. Then from the drop-down choose Begins with and enter FST you'll limited the displayed data. Once you've filtered you can simply select and delete the rows. -- ERR229 "Jed" wrote: Could some kind soul please advise syntex (macro)for deleting a row if first 3 character of a cell contains "FST" I have some value in column "H" which contains value FST,FST1,FST2 and so on. What i want to do is that if first 3 chracters in column "H" has a value "FST" then i want to delete that row. Thanks in advance Regards Jed |
All times are GMT +1. The time now is 11:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com