SUGGESTION: Looks like you have more data which you planned to handle in Excel, It would be better for you to switch to Desktop Application with Access DB (to reduce the running cost) or SQL Server as Back End.
The application can build in .NET framework (I am proficient in C#) , so I can built you a C#.Net Widows Application for kr 4000 (which permanently fix your problem)
NOTE: Simple 1 Hour training is required for your employees, So handling of huge data wont be a problem
OR if you want to update VBA Excel, I can make it up in kr 2000
Ping me, so we can discuss...
***CHECK OUT MY PORTFOLIO***
PROJECT PROPOSAL
PROJECT PROPOSAL
>VBA EXCEL APPLICATION / DESKTOP APPLICATION
**Requirement Gathering
**Layout Design approval in 10 Days
>IMPLEMENTATION DETAILS:
**Menus
**User Friendly Layouts
**Tips
**Context Menus
**Data Security
**Coding Standards
**Coding will be segregated, so Future function enhancement will be easy.
**Code Maintenance will be provided
About Me:
Building Windows Application for a US Based company in C#.
Experienced in DB Programming - ORACLE
VBA Excel Programming Experience:
1. Snapshot Excel 2 Power Point,
2. Pattern Detection Algorithm,
3. Sales Report Optimization,
4. Sales Analysis in Report
5. Merging on 2 Worksheets into 1 by Validation
6. Currency Conversion Macro Based on criteria
Expert Knowledge in Microsoft Excel, VBA Programming, Word, Power Point & Access.
Thanks,
John