Search Button with Data Return

I have a very large tool calibration spreadsheet with about 6000 rows of data. Im looking at created a Search feature which will return a few cells of information for ease of use. This spreadsheet is shared with about 100+ employees i know ctrl-f works but im just looking for a feature to make it quick and simple to look up tools.

I would like to enter the reference number and have the calibration due date, location, and certificate hyperlink be returned. Ive done some searching on the forums but cant seem to find the proper code.

Thanks Guys

"calibration due date, location, and certificate hyperlink be returned"
Where is the search to be done? Is it column B? If so, in which column are the returns to be copied?

Essentially B12 will be my input which will search [Reference Number] in table 1
B13 will return the [Calibration Due Date] in table 1
B14 will return the [Location] in table 1
and B15 will return the [Cert] in table1

I think you sheet cells are locked, can not see the rows below 14, so to get around this issue, I copied sheet1 in to sheet2 and can now see all the data. I have attached the code on to the search button on sheet2. I hope this would not create a huge problem.

Works wonders but on some items i try to look up on the actual database im getting


Run-time error '9'
Subscript out of range

Originally Posted by ja1234

Works wonders but on some items i try to look up on the actual database im getting


Run-time error '9'
Subscript out of range

Appologies i did not change the sheetname on my actual database in the code.

Works wonderfully thanks a bunch

Ja,
You are welcome!
Could you please now close (Mark) this thread as solved? Go in to the top right-hand side of this page, choose "Thread Tools" from the menu, then select "solved" from the drop down menu.

Hey all - End of day and bored, So I put this together from the original sample file. Using a few formulas on the far left to find the best match (1 criteria, 2, or all 3), I then wrote a marco to find and hide any unmatched rows... I did this in two seperate macros, allowing to 'Reset' and unhide if wanted.

Not sure if this is the solution you were looking for, but pretty user friendly with a ton of different applications. Check it out and let me know what you think.

Paul