Delete specific number of rows for each column with user input

.
You will need to clarify your goal.

It appears you are searching for a specific term, then want to delete the entire row the term is located on ?

I want to find a column using header name. Then in that column I need to delete specific number of rows. that specific number of rows changes according to the measurements we take here. It can be first rows or seven rows in that particular column. When i run the above macro, it deletes rows in all the column. I want to delete rows in that particular column, it finds.