Macro to search worbook with Key Inputs

[cooldebi]

I want a Macro for the following case:
In the “Search” Sheet I have entered the ‘roll no’ which I want to search in this excel workbook. I want to copy the entire row containing the ‘roll no’ in any data sheet to the “Result” Sheet. My workbook will contain many number data sheets(sheet2,sheet3,sheet4 here in this sample workbook). I have attached sample workbook here.
Please let me know if you need any more information.

Thanks

[arlu1201]

Are there chances of having many more sheets other than sheet 2, 3 and 4?

[Alf]

Perhaps a macro like this could be of help?

Please Login or Register  to view this content.

Alf

[cooldebi]

Yes, I will have many sheets not just sheet 2 ,3 and 4.

[cooldebi]

Thanks Alf for posting the Macro.

I tried but it is not working as per the requirement. Please see the "Result" sheet before running the Macro and after running the Macro. The Macro did not fulfill the requirement.

[nilem]

Another option (using Find). In the attached file push green arrow.

Please Login or Register  to view this content.

[Alf]

Humm, it seem that ActiveSheet.UsedRange does not work the same way in Excel 2007 as in Excel 2003.

Try this macro and see if it works better

Please Login or Register  to view this content.

This macro assumes that the search sheet is the first and the result sheet is the last sheet.

Alf

[cooldebi]

Very Good Job nilem
It was crisp and a very efficient Macro.

Thanks