My project sheet, is soundling similar to yours, but the area I cant seem to get down is this.
Multipule sections/offices/ entities will be updating thier respective colums of information, and what I WANT to happen is an automatic date populate in a predetermined cell. That way you can see that some value has changed.
Let say that HR does daily
personel attendance, they input into cells B5-B10
And Outside plant does the same in C5-C10,
Houskeeping updates cells D5-D10,
Under each cell (say B11 and C11 , D11) the date it was modified appear there.
The formula is what I'm missing. I am not understainfg how to make this happen.
Keep Up with TechRepublic