Macro to copy and paste selected cell to a table.

Hi guys,

Id be grateful for some help with this one.

I have made a sheet to speed up inputting items from a database to a quotation sheet.

Problem is the search works well the selecting of items not so well.

I'm trying to replace the tick boxes with a button which will copy the contents of the search in the cell on the left into the table and fill from top to bottom.

Also for a bit of added flair I was wondering if its possible to add a pop up box to ask for the quantity of the item required and add that to the cell right of the item selected.

Thanks for looking,

Adam

quote builder.xlsx