VBA code required

Dear All,

I am having a sheet with nearly 80 columns. This is customer complaints database. which contains
Complaint no.
Received date
Inspection date
Product ID
Repaired
....

...
Status...

And some hyperlinks (of .xls, .doc, .pdf, .jpg & .msg)

Now my Question is - I want to prepare a another sheet in same file which will give me all the details of Sheet1 for perticular Product ID.

That means There will be one Cell - Where I will put Product ID in Sheet2 & in below that It will show all the details in same columns as of Sheet1 (with hyperlinks ).

Please help me out for this.

Thanks & Regards
Narendra

Hi and welcome to the forum.
Seems like you don't need VBA code for this. Have a look at the excel funtion VLOOKUP.
It will look up one value (the Product ID) in a table (Sheet 1) and return the value from a specific collumn for row where the match was found.

-Terry