Few excel questions

Associate
Joined
18 Oct 2002
Posts
2,471
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.
 
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

yes just setup a macro

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.

im not sure it would update seperate files, dont think its possible, why dont you have 1 workbook with several different worksheets, then if you update the master sheet the remaining work sheets will be updated and also if you setup a macro then it would be easier editing as per your question 1
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.

not sure , try www.excelforums.com

why would you want to do that anyway?
 
Back
Top Bottom