Search and copy problem

[Herman]

I have a question.

i have 3 sheets, i like to search for a value for example 3 in the first 2 sheets
and if it is found in sheetsthen copy the row from the sheet and paste it in sheet3, the same for sheet2 if it is also found there then copy it in sheet3.
number of sheets is not always the same so i thought for each ws , but i get lost after it.

anyone knows how to search across multiple sheets and paste it in 1 sheet.

 

[Herman]

Thanx this is what i was looking for.
greetings, Herman

 

[Nimrod]

Might want to read the posting "find in multiple sheets copy in 1 sheet"

I've posted a solution there that I think may be applicable to your problem as well.

 

[NateO]

Herman, glad to hear this is working well. Incidentally, I've updated the code with an error trapper in the event that your search results in over 65536 rows, in which case Excel would bomb . Also, it inserts a comment in column A of each row telling you the sheet name and cell that the search term in that particular row came from. Figured this may be of help.

Nimmy, what's happenin'? I lived in Chilliwack, BC for four years or so. What happend to our Canucks?