Please help...

I need to know how to write a function or macro to copy the contents of
cell (A) to cell (C) and contents of a cell (B)to the comments of cell
(C). Additionally I need to execute this accross several sheets in a
workbook, how would I do that?


i.e. A1 copied to C1; B1 copied to the comments of C1 or
Worksheet1.A1 copied to Worksheet2.C5; Worksheet1.B2 copied to comments
of Worksheet2.c5.

Thanks for your help