Double click VBA to copy & paste to new list

Hello everyone. I've been trying to find an answer to my question in an existing thread, but haven't been able to do so. I apologize if this has been previously addressed.

I have a purchase order with all of our items and their corresponding item numbers set up. I've included a search box to limit results, as there are about 700 items included in the list. I would like to be able to search the item list, then double click on the item in the results to add to the actual PO. I am not good with VBA, but have pieced together a code that will copy a cell and paste it into the first line on the PO, but would like each subsequently clicked cell to be added to the next line.

Also, it would be ideal if I could double click the item on the PO to remove it, and have the following items move up automatically (so as not to leave a blank row).

Any help from the excel masters would be appreciated!

The search box is in J4, the results are listed in cells J6 through J25. I would like to double click on the results listed and have them copied and pasted into cell D8, then D9, and so on.

Also, if an item is added to column D from the results list, and the user then wants to remove it, I would like to be able to double click on a cell in column D and have that item deleted, and the rows shift up to eliminate the blank row.

Thanks!

Modifying your current code does this do what you require?

Please Login or Register  to view this content.

You guys are amazing! Thank you so very much!

You're welcome. Glad to help out, and thanks for the feedback.