Hello there,
I have a sheet with 56K lines in sheet1, I need to hide some of lines and delete some of lines in the sheet1 with macro.
For exp, which contains "AB.01" in A column so delete all the lines starting "AB.01" and wihch contains "BB9.1" hide all the rows which is starting "BB9.1" in the sheet1.
I tried like *AB.01*, *A*B*.*0*.1* somethings but couldnt do it.
Thank you for your help!
Bookmarks