I have very limitted use of Excel, but need to create a workbook that tracks $ due to our company based on visits completed.
For example, pt # 1 comes in for Visit 1 ($2300.00), Visit 2 ($1600.00), and Visit 3 ($1000.00). On Sheet 1 I want to track the Visits by placing an X in the box meaning the visit took place. On Sheet 2 I want the Totals to be calculated.....Pt # 1 = ($4900.00). This is just the beginning, but once I get this part down, I think I can tackle the rest. Hope someone can help. Please let me know if I did not explain this well enough.
For example, pt # 1 comes in for Visit 1 ($2300.00), Visit 2 ($1600.00), and Visit 3 ($1000.00). On Sheet 1 I want to track the Visits by placing an X in the box meaning the visit took place. On Sheet 2 I want the Totals to be calculated.....Pt # 1 = ($4900.00). This is just the beginning, but once I get this part down, I think I can tackle the rest. Hope someone can help. Please let me know if I did not explain this well enough.