How to refer to more than one sheet with With Sheets

Hi

Firstly, can you please review the forum rules regarding code tags, and then edit your post to wrap your code.

Then try

Please Login or Register  to view this content.

rylo

Hi Rylo,

Thank you for your help and your advice on the forum rules. I will do it next time. Your code works except I would like for it to find the cell value in any of those 3 sheets without having to tell me that it doesnt exist in the other worksheets.

Thank you again.

Hi

I have it set up, as per your original code, that if it finds a match, then it will move to that position. So if you have 3 sheets, the match is on the second sheet, exactly what do you want to happen?

rylo

I would like for it to go to the second sheet where the match is.

Mario

That is what it was doing on my test file.

So I can see exactly what your structure is, can you please attach an example file.

rylo

005.02.2 Commitment LA1.xls

Hi Rylo,

Here is my file (Hope it uploaded okay). There are other worksheets in the workbook, but at this time I am only concerned with sheets 8,9,10,11.

Thank you once again

Mario

aelgadi,

It works like a charm. Thank you so much.

If satisfied with a solution, don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

aelgadi

>>> If I helped, don't forget to add to my reputation (click on the star at left bottom of the post)