At work we are currently making a new spread sheet set up to manage figures etc (well we are testing it etc).
There are a number of different spread sheet files that are all the same apart from each one having some rows at the top with different info, the totals from them are all linked into a separate totals sheet.
But the main files spread sheets all have the same info area in them (ie same info in the cells size formatting etc) and have the info in some cells protected (ie so they cant be accidently wiped out) (these all have a grey cell fill) white cells are where the info is entered).
I know its possible to link cell info from one file to another but is it possible to link the cell formatting from one file to another.
Ie so we have a master template with the info area which the other files get the cell info, formulas and formatting from). (so that if we needed to add, delete cells/info etc we would do it via the master and the rest update from it.
The next one question is, is it possible to when an excel file is opened excel pops up a message asking for a name or (if possible an ID# which when entered it matches to a name and puts the name into a certain cell).
Ie open the file, excel asks for User # - enter 12345 and 12345 is linked/matched to Joe Bloggs and it auto enters it into the set cell.
There are a number of different spread sheet files that are all the same apart from each one having some rows at the top with different info, the totals from them are all linked into a separate totals sheet.
But the main files spread sheets all have the same info area in them (ie same info in the cells size formatting etc) and have the info in some cells protected (ie so they cant be accidently wiped out) (these all have a grey cell fill) white cells are where the info is entered).
I know its possible to link cell info from one file to another but is it possible to link the cell formatting from one file to another.
Ie so we have a master template with the info area which the other files get the cell info, formulas and formatting from). (so that if we needed to add, delete cells/info etc we would do it via the master and the rest update from it.
The next one question is, is it possible to when an excel file is opened excel pops up a message asking for a name or (if possible an ID# which when entered it matches to a name and puts the name into a certain cell).
Ie open the file, excel asks for User # - enter 12345 and 12345 is linked/matched to Joe Bloggs and it auto enters it into the set cell.
