I have a worksheet that is used for resource forecasting it has about 14 tabs
at the bottom. One of the tabs is a master that has all the names and a base
amount of hrs that one would work per month i.e. John Smith Jan 120, Feb 120,
Mar 138 and so on. The additional tabs are project tabs that has all the
names (that are listed on the master tab) the person then adds the amount of
time they will spend per month on a particular project i.e John Smith for
Project A in Jan will spend 50 hrs. The formula that I have calculates all
the hrs that the person enters on any of the project tabs against the Master
tab (50 - 120) the results then display on a Avaiable tab (that also has all
the names as the master) i.e. on the avaiable tab John Smith for Jan would
show 70.
My formula is a basic one it is in the cell for each person/month on the
Avaiable tab:
=Master!B4-SUM(DATA!B5,'712 '!B5,'COC Infra'!B5,'COC SLA'!B5,'FI
Hub'!B5,SONIC!B5,M2A!B5,FTP!B5,Radiance!B5,'Windch ill COP'!B5,'On
LOAN'!B5,Absence!B5)
..
What I need to do is anytime a row is inserted, deleted or moved on the
Master tab have it automatically update the Avaiable and Project tabs or if a
project tab is deleted have it Automatically update the formulas to remove
that reference