code of macro to copy

Hi,

I have some data in sheet A cells: C5, C7, C8
I would like to make Macro in sheet B. Macro should copy date from sheet A date C5, C7, C8 and paste it as value in C6 C8 C12 in sheet B. What code to use ? Something with select ?

Thank u for help.
Regards.

try something as:

Please Login or Register  to view this content.

Repeat in code for other cells