Hi,

How can I copy the data in and format of a cell on a sheet into a cell
on another sheet provided that the 2 sheets are in the same workbook?

Please note that I need to copy not only the data in a cell but also
the cell's format, for example, the size of the cell and colour of the
text inside the cell into another cell.

Thank you.

David