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