Form to Excel Filter function for dental procedure log
Hi everyone! First time user here that can’t figure out a complex problem in my mind:
I am in a dental residency with other coresidents where we have to create a log of all the dental procedures that we have completed. We would like to create a Microsoft Form that we can input the information for our procedures (ie: which location, patient age, how many of X procedure…). That data would show up on an excel sheet under one tab that has all of our aggregate inputs but then there are individual tabs for each of the residents that filters out our procedures that we have completed. That way, we can individually see our progress under my own tab while the program director can see the aggregate in tab 1. I was given a step by step in the past but it’s not working for me as to how to complete this. I’m very stuck!
Hoping someone can understand what I am trying to do and help out please! We would really appreciate it! Happy to describe more if there is some confusion.
Thank you so much!
Hi everyone! First time user here that can’t figure out a complex problem in my mind:I am in a dental residency with other coresidents where we have to create a log of all the dental procedures that we have completed. We would like to create a Microsoft Form that we can input the information for our procedures (ie: which location, patient age, how many of X procedure…). That data would show up on an excel sheet under one tab that has all of our aggregate inputs but then there are individual tabs for each of the residents that filters out our procedures that we have completed. That way, we can individually see our progress under my own tab while the program director can see the aggregate in tab 1. I was given a step by step in the past but it’s not working for me as to how to complete this. I’m very stuck! Hoping someone can understand what I am trying to do and help out please! We would really appreciate it! Happy to describe more if there is some confusion. Thank you so much! Read More