I have an excel sheet I am using for my doctors office. I have a column set like this:
MRN, Last Name, First Name, DOB, Medication, Frequency, Infusion Center/ Pharmacy, Phone/Fax, Status, Scheduled/Mailed, Comments
sheets A-Z and "Check Status"
Under the Status tab I have been putting "On Therapy" and "Pending"
I need to be able to have my "Check Status" Sheet automatically generate a copy of the Pending Patient's and their information.
We are constantly adding patients and I have been googling my butt off trying to find the best way to just be able to have a sheet set up that has a copy of the information above for pending statuses.
I have attached an example of what I am trying to do.
Please any information would be so greatly appreciated! I haven't really used Excel like this before.
