I have an excel workbook containing various calculations across multiple sheets.
The current workbook consists of 100 Data Entry & 100 matched Data Sheets (Pivot Tables), with the Collected Data being summarized on 6 Team Sheets, 1 Floor Summary & 1 Program Summary Sheet.(This is a Quality Tracking Spreadsheet, so every employee, has a pair of labeled sheets.)
The Data Entry sheets primarily consist of various Dropdown options with all of the Workbook Dropdown options consolidated on one separate Data Sheet.
1)I need someone to review the workbook calculations, currently there appears to be an error when calculating averages, on the Team Sheet based on entries made on the 'Employee' Data Sheets. (An average of two averages?)
2)When adding a new 'employee' Data Sheet, or relabeling a current sheet, the calculation tables on the Team Sheet change, requiring that each be rechecked & corrected manually. I need a work-around, either having the Spreadsheet correct the formulas automatically (preferred), or Semi-automatic process which will allow for a less labor intensive update (Each of the 6 Team Sheets has 5-7 tables, with up to 30 employees listed for each table). If one Name/Sheet is changed/added every table must be validated & corrected.
3)Suggestions for streamlining the spreadsheet to improve speed, and reducing it's size using Visual Basic.
46 pekerja bebas membida secara purata $125 untuk pekerjaan ini
Hello. Don't you want to rebuild your solution to the single compiled exe program with desktop database that does not require the MS Office to be installed for working? Plus - a high reliability and security. Regards