Copy selected cell values to another workbook based on cell color

[anuradha.vjc]

Hi

I receive a draft file from my counter part with some of the cells protected while there are selected (fixed cells) that are allowed to be updated which are colored.

I work on the draft file while the same values are to be copied to the final file received in the same format in the same colored cells.

The file is huge and takes lot of time. Request if there could be a vba code that can copy the value of the draft file to the final file?

Please help

Regards
Anuradha