Try reading the code as you would a book that is all it it is.
the For each Ws in ...
you read for each worksheet that I have in my workbook
the next line (modified for your sheet2 and 3) you ask the question if the worksheet is named sheet2 or if it is named sheet3 then
check in all cell's values if part of the text you're searching matches what you have entered and ignore the case sensitivity
if a match is found, select that cell and stop
That is what the code does and that is how all code works
So what you do is write down the actions YOU would do to achieve something with if this then that else something else and after you have written it down you write it as vba code respecting the syntax.
You tube isn't too bad but look up tutorials that explain code and have sample workbooks and play around.
There are many sites, Ozgrid, Peltier, Walkenbach, Ron de Bruin and of course a forum like Excel Help where you can look at what others asked and did
HAppy coding
Bookmarks