Check value and copy the color to a new sheet's cell

**rmachbitz** · 07-15-2013, 06:26 PM

Basically I would like to take the file I've attached and take the Case number, for example 224.4642857, and copy its corresponding color from the Box Height to the new sheet called "Slotting". I have looked online for various code and do not know how to do this. Can someone please help?

Please Login or Register  to view this content.

Coolstuff.xlsm

**Norie** · 07-15-2013, 06:37 PM

So first you want to find the case and that isn't working?

**rmachbitz** · 07-15-2013, 08:35 PM

I can do a vlookup for the Case number but I don't know how to copy the color from the Box Height corresponding to the Case number into a new sheet.

**Norie** · 07-15-2013, 10:07 PM

Why do you never refer to the other sheet, Slotting, in the code?

**Norie** · 07-15-2013, 10:21 PM

Please Login or Register  to view this content.

**rmachbitz** · 07-15-2013, 10:49 PM

Thank you again

Check value and copy the color to a new sheet's cell

LinkBack

Thread Tools

Rate This Thread

Display

Check value and copy the color to a new sheet's cell

Re: Check value and copy the color to a new sheet's cell

Re: Check value and copy the color to a new sheet's cell

Re: Check value and copy the color to a new sheet's cell

Re: Check value and copy the color to a new sheet's cell

Re: Check value and copy the color to a new sheet's cell

Thread Information

Users Browsing this Thread

Similar Threads

Check cell Value in range and copy specific cells to another sheet

[SOLVED] Copy Cell.Font.Color from Sheet A to corresponding Sheet B

[SOLVED] Copy a row to another sheet based on cell fill color

Check cell content has green color then mark as yes in another sheet.

Copy, paste cell from one sheet to another sheet creates different color

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions