Hi,

I have a worksheet (sheet 1), I would like to copy both text and
formatting automatically to another worksheet (sheet 2) in the same
file. I can copy the text easily by referencing to the applicable
cells (e.g. =A2), however, this does not copy the formatting
over.Ongoing formatting changes will be completed for sheet 1 which
can vary from change in cell colour, font colour or font style
depending on the cells and I want these changes to always be reflected
in sheet 2. Is there a macro I can use to perform this?

Thanks!