Hide rows in multiple worksheets based on a condition using a macro in vba

[MISS_AJAZ]

Hi,

I would like to create a macro for the following scenario, (I have used the worksheet names as per how they are in my workbook):

I would like to hide rows in column A with the word 'No' in, I need this to link to these 3 worksheets: 1st fit, 2nd fit, 3rd fit.

There are other worksheets within that workbook which I do not want linking.

I hope above makes sense and someone will be able to help me!

Thank you

 

[Michael M]

Already allowed for that with this line

option compare text

 

[MISS_AJAZ]

Fantastic thank you