I'd like excel to write the time when one of my macros tells it to copy and paste some cells into another workbook. I'd like it to paste the time into the other workbook. Any help would be much appreciated.

sorry, didnt read the whole thing!
cheers man