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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying Selective Data Between Worksheets 5
Excel lookup across entire workbook 1
Recalc of SUM() that refers to a cell across a range of worksheets 4
Populate Data from Summary Sheet 5
data to summary sheet for a dummy 0
Excel VBA 1
Conditional format Column based on Week Date 2
Blank Cell Reference, without if statement 4

Back
Top