Search query help required

=PROBLEM SOLVED, thank you DonkeyOte=

Hi there,

I need a macro that can search through all of my worksheets bar the first one looking for the string given by the value of cell (sheet1,A,2). If it finds the string in sheet2 it should fill cell (sheet1,B,2) with the string "True". If found in sheet3, it should fill cell (sheet1,C,2) with "True", etc.

Once it has done this, it should be able to loop and do the same for the string given in (sheet1,A,3), etc.

Looking back on what I've just written I'm not sure how well I've explained myself, so I'll try to convey what I want done in pseudocode:

Please Login or Register  to view this content.

Hopefully that'll explain what I want done and hopefully one of you macro-geniuses will be able to help me!

Cheers!

Hi Try this,

Please Login or Register  to view this content.

Regards,
Salim

Hi,

I make some changes in code.

Below is the code,

Please Login or Register  to view this content.

Regards,
Salim

Here is another variant on the same theme....

Please Login or Register  to view this content.

So is the sheet containing the search criteria the left most sheet in the workbook ?