I have come across a problem with a spreadsheet im using for holiday and
sickness tracking.
I have a table with countif working on it, so everytime i put a "h" in the
table it counts as one in the total number of days holiday cell, which is
subtracted from the allowance and the result is displayed in the remaining
days cell.
My problem is, if for example, if i put in 10 days of holiday for someone in
march the remaining days in march will go down, but for the rest of the
months it will stay the same.
How do i link the remaining days on all sheets so that when i put 10 days
holiday in march it takes the remaining number of days down in the rest of
the months sheets.
Thanks for your help,
im not exactly an excel wizard i know.
Darryl