My dear!
There are 12 columns(months). 50 rows each column.
Each is marked by its own color. SAy cell G5 data ( in January) is
marked green and i need to transfer cell data to H5 (Feb)blue.
I need the cell color(green) be changed for (blue) automatically. So
at the whole table.

How can i do it using VBA ? Or something else. Help me please.
Serge.


--
Kaibutsu
------------------------------------------------------------------------
Kaibutsu's Profile: http://www.excelforum.com/member.php...o&userid=26168
View this thread: http://www.excelforum.com/showthread...hreadid=394867