Creating Multiple Entrys

D

DarklyCute1

Not really sure how to name this one - but here's an explination about
what I'm trying to do. I'm working on creating an employee absence
tracker and I'm nearly finished but I didn't take into acount for neww
hires or retired/fired people. The workbook consists of a year to date
kind of thing followed by the months of the year.
Is there a way to add boxes (10 rows X 14 columns = ytd ; 10 rows X 6
columns = monthly) for the new people and subtract boxes for the old
ones leaving without messing with the values of others (this is in
alpha order)
Also, Is there a way to correspond the boxes, when one gets added in
the ytd it's automatically added to the other sheets (all months).
Sorry if this seems confusing, I can answer any qs.
Thanks,
Darkly
 
Top