Copy data including coloured cells automatically to another sheet

[Maz71]

Hi
Could anyone please advise how I can get coloured cells to update automatically on another sheet in the same workbook in excel. My sheet is looking at the first tab and working well, but if I change s cell colour on the original to say grey it doesn't update.
Thank you
Maz

[Aussiebear]

Try the following;

Sub Copy_with_Formatting()
Range("A1:E21").Copy Destination:=Sheets("Sheet2").Range("A1")
End Sub

Change the selected range on the active sheet to suit and change the name of the destination sheet to suit as well

[georgiboy]

It depends on what you are using the information for on the second sheet, if it was for a dashboard or something then you could look to use the paste special option for a linked image.