Thread: returning format from another spreadsheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default returning format from another spreadsheet
The link formulas in the master return only the values, not the formats.
Copy the source cells and pasteSpecial format onto the master cells.
--
Gary''s Student - gsnu200835


"kefee85" wrote:

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?
Reply With QuoteReply With Quote