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!

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

Hi,

Does the attached help.

First choose the cell in which you want the colour to be copied. Then click the Find button then the Copy Button

Originally Posted by Richard Buttrey

Hi,

Does the attached help.

First choose the cell in which you want the colour to be copied. Then click the Find button then the Copy Button

That's extremely helpful. Is it possible please to have the "find" look for text and alpha numerics aswell?

If you look at the colours (first one for example, then there's more at the bottom) some are "process yellow", "warm grey 6" etc, so as long as the user types the correct name, this should give the same result as the number search you have kindly provided.

The alternative would be a manual copy paste of the alpha/numeric based codes, but this is cumbersome (aswell as not very user friendly), as you can see the colour and code are in different cells.

Thanks again for your help.

Hi,

Yes, just substitute the following which now allows for string entries to the Input box

Please Login or Register  to view this content.

Please Login or Register  to view this content.