master sheet

H

hockey nut

I have a workbook with a over 10 worksheets,I have one
sheet I call the Master, I would like that any changes I
make to it are reflected in the other worksheets only if
the are effected by the change to the master, eg on the
master sheet I delete a game from the Atom's but make it a
practice for the Peewee's, I need the game to be removed
form the atom worksheet and a game inserted on the peewee
worksheet, right now I do this manually i know there's got
to be a easier way, with only doing my work on the master
sheet. any help would be greatly appreciated.
 
D

David McRitchie

If those other worksheets can be generated from the Master
based on the value in a column then you can probably do away
with them and use a filter. Top row should have titles for columns.
Ctrl+A, Data, Filter, AutoFilter
to remove all traces of the filter (like if you don't like this)
Data, Filter, AutoFilter

More information on Filters
Excel Filters -- AutoFilter Basics (Debra Dalgleish)
http://www.contextures.com/xlautofilter01.html

You *pull* values from other places in Excel, if you try to think
in terms of *push* values to another place you will cause yourself
a lot of extra work. More specifically the main thing used in
a spreadsheet are formulas and constants. The formulas are
functions, and functions cannot change anything in any cell
including itself. All a function can do is return a value.

Usually when you have a Master you summarize detail from
other places. An Example of summarizing data from
specific places in other worksheets see
Build TOC Another Approach
http://www.mvps.org/dmcritchie/excel/buildtoc2.htm
 
Top