Thanks Tom:
Different companies are coded different colors on
one "daily buy report" and I have to have that data sent
to the appropriate company's invoice rather than him
typing it again into the invoices. We're talking 10
different companies, "colors", 10 invoices, and as many as
20 different varieties of products, prices and Pounds.

The address of the destination cells in the invoices will
vary depending on the type of product, the color only
tells me what invoice it goes to. I may need this code to
be a little more specific if possible, Please?

SkipC

-----Original Message-----
Send to different invoices. What does that mean

for each cell in Activesheet.UsedRange.specialCells
(xlconstants)
select Case cell.Interior.ColorIndex
case 1
' send to invoice
case 2
' send to invoice
case 3
' send to invoice
case else
end Select
Next

--
Regards,
Tom Ogilvy

Skip Christensen
wrote in message
...
My boss wants to select certain cells and code them with
color and have them sent to different invoices depending
on that color. Can I write some code or get it from
somewhere that will do that for me?

Thanks

SkipC


.