returning format from another spreadsheet

  • Thread starter Thread starter kefee85
  • Start date Start date
K

kefee85

I have a master calender spreadsheet that references three department
calender spreadsheets. I would like to master to reflect the format of the
cell it references, not just the value. Any ideas?
 
The link formulas in the master return only the values, not the formats.
Copy the source cells and pasteSpecial format onto the master cells.
 
Unfortunately I can't cut and paste special since the cell is dynamic and the
master needs to reflect the change. Any other ideas?
 
There is no easy way to do what you have asked. Even using macros what you
want to do is a bit tricky as changing a format does not trigger an event so
there is no easy way to react to the change.
 

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

How do I link data from an Excel spreadsheet to a calender? 1
Lookups - how to obtain data from a master spreadsheet into another 5
Conditional Formating based on start and end dates 1
Locating Source Data in Master Spreadsheet 3
hyperlink to cell based on formula results 4
Excel 2007 spreadsheet references older office spreadsheets 2
insert calender into excel 1
Referencing Worksheets in separate Workbooks 5

Back
Top