How do I create a set of sheets that will update from a master?

  • Thread starter funky_funky_almonds
  • Start date
F

funky_funky_almonds

I'm using excel to outline a publicity campaign for 4 groups. I want one
overall sheet with all the groups and seperate sheets with more detailed info
- is there anyway of typing into both a master copy and an other copy at the
same time?
 
I

Ian

You can reference a cell in another sheet eg in A1 on Sheet1 enter
=Sheet2!C4 so that whatever you type in Sheet2 C4 also appears in Sheet1 A1.

It sounds like you want a summary sheet and 4 details sheets. In a cell on
the summary sheet, type = into a cell, click on the tab of one of your
detail sheets, click the cell you want duplicating and press enter. The
formula will be built as you progress.

Once you have all the entries in place, it would be a good idea to protect
the summary sheet, so nobody can enter data into it and overwrite the
formulae.
 
P

Paul Sheppard

funky_funky_almonds said:
I'm using excel to outline a publicity campaign for 4 groups. I wan
one
overall sheet with all the groups and seperate sheets with mor
detailed info
- is there anyway of typing into both a master copy and an other cop
at the
same time?
Click to expand...


Hi f_f_a

Try using links

On the sheet you want to link to the master sheet type = into the cel
you want linked to the master sheet cell, then click in the cell yo
are linking to on the master sheet and hit Enter

Now when you type into the cell on the master sheet, the cell on th
linked sheet will show the same inf
 
Top