Here is a **professional, ready-to-use prompt** you can give to a designer, Excel expert, or even an AI tool to create your file: --- ## **Professional Prompt for Patient Record Excel Sheet (Shifa Online Consultation)** Create a **professional, hospital-style Excel workbook** for managing patient records for an online consultation system named **“Shifa Online Consultation”**. ### **Workbook Structure** ### **Sheet 1: DATA ENTRY FORM (User Interface Sheet)** Design this sheet as a clean, form-style interface where user manually enters patient details. #### **Fields to include:** * Serial Number (Auto-generated) * Patient Name * Father / Husband Name * Age * Gender * Contact Number * City / Location * Disease / Complaint * Doctor Name * Consultation Date * Appointment Time * Consultation Fee * Reports / Notes * Prescription Notes * Follow-up Date (if any) * Status (Pending / Completed) #### **Design Requirements:** * Clean form layout with labeled input fields * Professional hospital-style formatting * Drop-downs for Gender, Status, Doctor Name * Date & Time format validation * Auto serial number generation * Submit button (macro or form button) #### **Functionality:** * When user clicks **Submit**, data should automatically transfer to Sheet 2 * After submission, form should clear automatically for next entry * Data validation must be applied for missing or incorrect fields --- ### **Sheet 2: DATABASE / RECORD SHEET** This sheet should store all submitted records in table format. #### **Columns:** * Serial No. * Patient Name * Father/Husband Name * Age * Gender * Contact * City * Disease * Doctor Name * Date * Time * Fee * Reports/Notes * Prescription * Follow-up Date * Status #### **Design Requirements:** * Excel Table format (structured database) * Filter option on all columns * Search-friendly layout * Auto timestamp optional --- ### **Branding & Visual Design** * Add **“Shifa Online Consultation” logo** on top of Sheet 1 * Apply logo as a **light watermark background** on both sheets (low opacity, center aligned) * Use professional medical theme colors: * White background * Light blue / teal highlights * Add header title: **“Patient Consultation Record System”** --- ### **Automation Requirements** * Auto Serial Number generation (incremental) * Submit button moves data from Sheet 1 → Sheet 2 * Print-ready formatting on Sheet 2 * Page layout optimized for A4 printing * Optional: Print button on Sheet 2 for instant report printing --- ### **Final Output** The final Excel file should be: * Fully professional hospital record system * Easy for non-technical users * Print-ready patient report system * Secure, structured, and clean database design
Shifa Online Consultation - Patient Record System
| File | Purpose | Download |
|---|---|---|
| Macro-enabled workbook | Open in Excel, add VBA | Shifa Patient Records XLSM File · XLSM |
| Standard workbook | Use as-is or in Google Sheets/LibreOffice | Shifa Patient Records Spreadsheet · XLSX |
| VBA Macro source | Paste into Excel's VBA editor | ShifaMacros BAS File · BAS |
What's Inside
Sheet 1 - DATA ENTRY FORM
- Professional hospital-style layout with deep teal / white / gold color scheme
- 3 sections: Patient Information, Clinical Notes, Follow-up & Status
- All 16 fields as labeled input cells with clean borders
- Auto Serial Number formula (reads max from Database + 1)
- Drop-down validations for: Gender, Status, Doctor Name (5 doctors listed)
- Data validation for Age (1-120 whole number), Fee (positive decimal), Dates
- SUBMIT RECORD button (teal) and CLEAR FORM button (red) - styled cells
- A4 portrait print layout with header/footer
Sheet 2 - DATABASE
- Structured Excel Table with auto-filter on all 17 columns
- Columns: Serial No. through Status + Entry Timestamp
- Freeze panes below the header row
- Alternating row shading (conditional formatting)
- One sample record pre-filled (greyed out as a guide)
- A4 landscape print layout, fit-to-page, repeat headers on print
Activating the Macros (3-minute setup)
- Open Shifa_Patient_Records.xlsm in Excel
- Press ALT + F11 to open the VBA editor
- Right-click VBAProject → Insert → Module
- Open ShifaMacros.bas in Notepad, copy all the text, paste it into the module
- Press ALT + F8 → test
SubmitRecord - Right-click the SUBMIT RECORD cell on the form → Assign Macro → pick
SubmitRecord - Right-click the CLEAR FORM cell → Assign Macro → pick
ClearForm
What the macros do
- SubmitRecord - validates all mandatory fields with clear error messages, writes the row to the Database with auto serial number + timestamp, colour-codes the Status cell (green/amber/blue/red), then clears the form automatically
- ClearForm - wipes all 15 input cells and returns focus to Patient Name
- PrintDatabase - prints Sheet 2 in one click
- PrintCurrentForm - prints the entry form