removing specific rows in a worksheet
Hi Louise,
Check the blanks between Store and Manager, my code is working for me
"Louise" wrote:
Hello
This does remove the text, however the row itself remains, I need to remove
the actual row too. Any ideas?
Thanks.
Louise
"Sheeloo" wrote:
Filter on 'Starts with' Store Manager
Delete the filtered rows
(You may have to press F5 and Choose Special and then click on Visible Cells
only)
Do make a copy before experimenting or make sure that you do not save till
you are satisfied with the results.
"Louise" wrote:
Hi all
I have a large worksheet containing thousands of rows beginning with the
words 'store manager'. I need to remove every row in the workbook beginning
with these two words.
Is there an easy way to do this?
Thank you.
Louise
|