selected colour cell will save / show in new sheet or within the sheet

[amar.kshirsagar]

Hi All,

Require your valuable guidelines again

Can mouse selected colour cell will save / show in new sheet or within the sheet, with the respective heading.

I uploaded illustration file.

I already posted this thread

HELP - Selected cell will display in new sheet (http://www.excelforum.com/excel-programming-vba-macros/1015996-help-selected-cell-will-display-in-new-sheet.html)

Thanks in advance

Amar K

[amar.kshirsagar]

any suggestions