Can you create master sheets within excel

  • Thread starter Thread starter MICHAEL WYBORN
  • Start date Start date
M

MICHAEL WYBORN

Help:

Is it possible to create mastersheets within excel. What i
mean is I want to create one work sheet and if i change
that sheets that it can change other (but not all)
worksheets within that spreadsheet.
 
MICHAEL WYBORN said:
Help:

Is it possible to create mastersheets within excel. What i
mean is I want to create one work sheet and if i change
that sheets that it can change other (but not all)
worksheets within that spreadsheet.
Click to expand...

You can write formulas on as many other worksheets as you want that
reference cells on one worksheet (that you might choose to call
'mastersheet'). Then, when mastersheet is updated, all other worksheets will
change. Note that formulas always 'pull' data; each one can only change what
is in its own cell.

Alternatively (or in addition) you can write VBA code, triggered (perhaps)
by a change in mastersheet, that can 'push' data into whichever cells you
designate.

Does this help?
 
-----Original Message-----


You can write formulas on as many other worksheets as you want that
reference cells on one worksheet (that you might choose to call
'mastersheet'). Then, when mastersheet is updated, all other worksheets will
change. Note that formulas always 'pull' data; each one can only change what
is in its own cell.

Alternatively (or in addition) you can write VBA code, triggered (perhaps)
by a change in mastersheet, that can 'push' data into whichever cells you
designate.

Does this help?


.it does help in one respect, but can you for example add
Click to expand...
a row in a "master" than that changes other worksheets
adding a row for you in these as well
 
A different approach: Maybe you can live with filtering on your master
worksheet. Select your range, then data|Filter|autofilter.

You can pop up just the rows you want to see. You can apply different filter
criteria to more columns and refine your filter to hide more rows.

My opinion only: I wouldn't try to set up a master worksheet--too many things
can go wrong. If the user just opens the workbook with macros disabled, you'd
have big trouble. Then there's the chance that someone makes a change to the
child worksheet--the change never gets back to the master.

If the filtering doesn't work for you, maybe you could have an on-demand macro
(not tied to an event) that separates your data into the sheets--actually tosses
the old and rebuilds each time you run it.
 
Back
Top