I work in a medical office and am trying to track patient visits. I have One worksheet (SheetA) that has all the patient Names and demographic info in a table, and also includes how many visits that patient has been authorized to receive and a column with the number of visits remaining. In another work sheet (SheetB) we have a charge list with all of the patients that have come on that day (we make a new one everyday). I am trying to make it so that when a Patient appears in SheetB the number of visits remaining for that patient in SheetA is reduced by one. Is this possible and if so how would I go about doing it. Also I am starting to think this might be better done in Access, but I am much less familiar with it than Excel so I am unsure. Any Help would be appreciated.
Thanks!
Thanks!