Search the value in multiple sheets and display the entire row of matched value in list bo

[haridevadiga]

Hi Friends,

I am getting an error while working on below code:

Please Login or Register  to view this content.

This above code search the value and display the entire row of matched value from one sheet.

Now what i want is this it should search in multiple sheet and display same (the entire row of matched value)

Can anyone help me out in this.

Regards,
Harindra Devadiga

[Tnashnhsp1]

Have you tried adding another For and Next around your code to go to the next sheet after running it?

like

Please Login or Register  to view this content.

Just be careful of referencing any named ranges in your code for the sheet in which you are searching that may not exist in another sheet

[haridevadiga]

Can you please code it....

[Tnashnhsp1]

If you attach the workbook you are working on I or others can give it a go to make sure it works

[haridevadiga]

Unit_Department_Details.xlsm

Hi Friend,

In Attached file, you will find three sheet (Enter, Data & Sheet1). In Enter sheet you will find a button which will pop up the userform, by which you can only search in Data Sheet right now.

1) From that userform a user can search two sheet (Data & Sheet1)
2) Once we entered the code in the search details form,a user will get a entire row output in listbox, which will redirect the user to particular sheet.

Regards,
HD

[Tnashnhsp1]

Hey, this is a little rushed because i am at work but paste this in to the 'view code' section of the search button in the user form and replace your existing code. I have tested it and it searches both sheets (tested by adding a new unique row in the other sheet and it came up)

Please Login or Register  to view this content.