Macro to copy

Hello all you "Brilliant Minds" here is a chance to prove your "Excel-ence. I want to copy  a value to one cell from the source which is random and as I haven't a clue about this stuff I asked Micros...