Hello all.
Hopefully I can explain and ask this question correctly... So I have finally figured out my Excel spread sheet problems, almost anyways. So right now I have my sheets sheet up to return a value under a specific date. For example, I have an employee booked to work on my daily schedule (Sheet 1)for Jan 15. On sheet2, I have the days of the month across the top (cells A1 to AG1), employee name from cell B1 to B52. So when I plug my worker in to a spot on Sheet1, it automatically input "worked" under the Jan 15th cell on sheet 2 and it works great . My only problem is, on Jan 16th, it will show that the employee has worked in the Jan16th cell, but the jan 15th cell now shows he was off, basically not saving the previous days info. So my question is, Is this where creating an Acess database would come in handy, so that my previous days info will be saved and not reset?
Hopefully I can explain and ask this question correctly... So I have finally figured out my Excel spread sheet problems, almost anyways. So right now I have my sheets sheet up to return a value under a specific date. For example, I have an employee booked to work on my daily schedule (Sheet 1)for Jan 15. On sheet2, I have the days of the month across the top (cells A1 to AG1), employee name from cell B1 to B52. So when I plug my worker in to a spot on Sheet1, it automatically input "worked" under the Jan 15th cell on sheet 2 and it works great . My only problem is, on Jan 16th, it will show that the employee has worked in the Jan16th cell, but the jan 15th cell now shows he was off, basically not saving the previous days info. So my question is, Is this where creating an Acess database would come in handy, so that my previous days info will be saved and not reset?