Hi there
I am new to VBA on excel. Can someone help please.
I have a spreadsheet of many columns and rows. I need to find the word "Record Id" (which is normally in column A somewhere) and then delete 10 lines from where the Record ID word is.
Right now I have to do it manually by searching Ctrl + f and then selecting 10 lines and deleting. But if I can have a code, it will be much faster.
Thanks
I am new to VBA on excel. Can someone help please.

I have a spreadsheet of many columns and rows. I need to find the word "Record Id" (which is normally in column A somewhere) and then delete 10 lines from where the Record ID word is.
Right now I have to do it manually by searching Ctrl + f and then selecting 10 lines and deleting. But if I can have a code, it will be much faster.
Thanks