Excel VBA code to search and export (results) to pdf - Reporting tool

[jmeddaugh]

Hello!

I have a challenging task.

I have an school district Inventory excel document with many sheets. I would like to create a button or userform that would bring up a text box and when the user enters data, and clicks on find and export it would find all matching data and export the matching row to a pdf.
For example searching for Dell OptiPlex it would export all rows with "Dell OptiPlex" in them to a pdf.
I am not sure if this is even possible.

Thanks in advance for your time!

 

[My Aswer Is This]

Yes then can be done.
I need to know what column we should look in for the value entered into the InPutBox