returning format from another spreadsheet
 

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?

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?

returning format from another spreadsheet
 

Unfortunately I can't cut and paste special since the cell is dynamic and the
master needs to reflect the change. Any other ideas?

"Gary''s Student" wrote:

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?

returning format from another spreadsheet
 

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.
--
HTH...

Jim Thomlinson


"kefee85" wrote:

Unfortunately I can't cut and paste special since the cell is dynamic and the
master needs to reflect the change. Any other ideas?

"Gary''s Student" wrote:

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?