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