Delete Row based on cell value through multiple worksheets

Hi,

I have used a Macro that looks at the values in a certain column and deletes the row if it meets the specified criteria, in this instance it is any grade that is an F or higher, code below.

Please Login or Register  to view this content.

The macro works which is great. However, the workbook I am working on has multiple worksheets which also need to be checked using the same rules but the column order varies. For example, in Sheet1 the data is in column 16, in Sheet2 the data is in column 10....each column has the same heading.

Is there a way of identifying which column holds the relevant data, select it and then run the above VBA?

Any help would be greatly appreciated.

That's another piece of the puzzle....Each Column will have the same Heading so is there a way of scanning the row with the column headings, identifying the one we want, "Grade Level", and then performing the deletion macro?

Thanks