Excel Prescription Tracker Enhancement
Budget: $250 – $750 USD
I need an experienced Excel and Word professional to update my prescription tracking spreadsheet. The update should automatically create refill dates, color-code alerts based on proximity to the due date, and transfer specific data to a Word document when a refill is due.
- Color Coding:
- Red for prescriptions due in 7 days
- Yellow for those due in 14 days
- Green for 30-day alerts
- Word Document Data:
- Patient name
- Prescription details
- Patient address
- Exam and lab date
- Prescription refill date: Include the next refill date in the Word document data.
Ideal candidates should have strong Excel skills, experience with automating tasks in spreadsheets, and proficiency in Word. Prior experience working with medical or prescription data is a plus. Please ensure your bid reflects your understanding of these requirements.
The data transfer from Excel to Word should use a platform or tool that you are comfortable with.
- Color Coding:
- Red for prescriptions due in 7 days
- Yellow for those due in 14 days
- Green for 30-day alerts
- Word Document Data:
- Patient name
- Prescription details
- Patient address
- Exam and lab date
- Prescription refill date: Include the next refill date in the Word document data.
Ideal candidates should have strong Excel skills, experience with automating tasks in spreadsheets, and proficiency in Word. Prior experience working with medical or prescription data is a plus. Please ensure your bid reflects your understanding of these requirements.
The data transfer from Excel to Word should use a platform or tool that you are comfortable with.