vba for a multiple searchable dropdown list and copy data by checkbox to another sheet

What data would be in the drop down list?

You should be aware that a data validation drop down list is not searchable. There are ways of making a searchable list but it involves using a combo box and can be quite involved. If this is the way you want to go, could I suggest that you search online for something like "create a searchable drop down list in excel". There is a lot of information and instructions on how this can be done. I would like to suggest another approach to see if it would work for you. You could be prompted with a message to enter a search value. It could be a reference number or the description of goods. This would require that you knew the exact reference number to enter or the exact description of goods to enter. Another simpler approach would be to find the row on your data sheet that you want to copy and simply double click the first cell in column A of that row to automatically copy the range to the other sheet. This approach would also eliminate the need for the check boxes. Would any of these approaches work for you?