Excel File for Language School Refunds - 09/09/2024 19:58 EDT
$250-750 USD
Dokončeno
Zveřejněno před 4 měsíci
$250-750 USD
Zaplaceno při doručení
I'm seeking an Excel expert who can fix and optimize our tuition refund calculation file for our language school (includes a data entry form).
Issues to be addressed:
- Fix errors in data storage
- Certain cursor movements need to be programmed
Data storage:
- All refund records currently stored in one table, on a dedicated tab. (But when records are saved, the formulas in the main Refund Calculation tab are deleted and replaced with values. The formulas in the cells must be preserved when records are copied to the data storage tab).
Automation:
- Program the file to automatically move to the next cell after input
- Jump to a specific cell based on input
Ideal skills include:
- Advanced Excel skills
-Experience with Data Entry Forms in Excel
- Experience with Excel VBA or Macros
- Ability to troubleshoot and fix complex Excel issues
- Excellent attention to detail
Need work completed within 2 to 3 weeks. I will provide the existing file for your assessment. The password for the main Refund Calculation tab is "Vivek" if the password protection comes on.