I have to maintain a record of community service hours owed and worked by my clients. Sometimes I have new clients and have to add them to the sheet, sometimes clients finish or move away and I don't need them on the next months sheet. As a third problem, sometimes clients will have hours added to what they owe. How do I do these things at the start of a new month? How do I do it in the middle of a month?
Is there a way to lock data to a clients name across several sheets? Ie. Becky Johnson becomes Becky Smith, if I move her does it mess up the whole workbook?
"Problem" sheet would be October below the names are some examples of actions I need to take.
Bookmarks