Referencing Formatting Across Worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Link does not link formats. You could create a macro to perforn the
Copy/PasteSpecial rather than do it by hand.
 
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
 
Back
Top