Referencing Formatting Across Worksheets

[Tiny300]

Hi,

I'm trying to make a summary of a source worksheet and am able to copy the
data across using: 'Sheet1'!A:A , but I also need to formats (Cell
width/Shading/Font/Border) to be referenced across as well, so that any
updates (e.g. inserting a row) in the source sheet are updated in the
resulting summary.
Any ideas?

Many thanks

 

[Gary''s Student]

Link does not link formats. You could create a macro to perforn the
Copy/PasteSpecial rather than do it by hand.

 

[Tiny300]

Thank you for your reponse. But if data can be copied this way, surely
formatting could be replicated in the same way. Also if I write a macro would
this update the
summary sheet everytime sometime changes on the Source sheet.

Many thanks