Search, filter and populate spreadsheet

[Bevilready]

Hello, I have a spreadsheet in which I would like to be able to use a search box to filter through a list of products and add a quantity to each item I search for. After which I'm would like the items I have put quantities against to appear in a separate list, which would become an order to send to my supplier. I have been able to create a search, but am not able to put a quantity in the cell which remains once the search is cleared.
Can anyone help me please?
Thanks,
Bevilready

 

[Bevilready]

That works well...
The only changes I would make would be to move the Re-Set button on to the Order tab, so that the order can be cleared after sending and then having another button on the Products tab which clears the filter on the 'Tender Item & Specification column.

 

[mumps]

Right click on the Re-Set button. Then right click again on the border of the button while the cursor looks like a cross and click 'Cut". Go to the Order sheet. Click on cell K2. Hold down the CRTL and press the letter "v". This will paste the button. You actually don't need a button on the Products tab to clear the filter. Just click on the Data tab in the top menu and click the "Autofilter" button.
Replace the current ReSet macro with this one:

Sub ReSet()
    Range("A3", Range("I" & Rows.Count).End(xlUp)).ClearContents
    Sheets("Products").Range("E5:G" & Sheets("Products").Range("A" & Rows.Count).End(xlUp).Row).ClearContents
End Sub

 

[Bevilready]

Fantastic, thanks ever so much for your help. I'll leave you alone now......... until I break it again.

 

[mumps]

You are very welcome.