find, copy and paste pantone colours into chosen cell

Hi there,

I have a list of pantone colours that have for example first colour (actual colour) in a1, and the colour code of that same colour in a2. The colour list is about 6 columns wide and follow the same format as just described.

I have a seperate table in the same sheet with fields "PRODUCT" "PANTONE 1", "PANTONE 2" (up to Pantone 5).

The logic is this:

1. There is a search box and "Find pantone colour" button. I want the user to be able to find the pantone colour by its colour code (typed in).The search box autocompletes when a colour code is typed (there are about 600 colours or so), but the find button should take the user to the cell that corresponds to the colour code in the search box (to visually verify)

2. Once colour found another button "Copy pantone", does exactly that and copies the colour and the code (note locations of both in initial paragraph). I assume "active cell" will be handy here?

3. There is then a paste button which i want the user to be able to chose which "Product" and then which "PANTONE COLOUR" cell (1 to 5) to put it in on the seperate table (see initial paragraph). Note the colour (for e.g) is in a1 and the code in a2, however it is not a problem when the colour and code is pasted for it to be pasted in ONE cell on the table.

4. Pantone colour and code then gets pasted in the chosen product row and pantone cell on the table.

Would appreciate some help with the coding of the buttons please?

Thanks for any help!