Excel Workbook Update/Correction

I have an excel workbook containing various calculations across multiple sheets.

The current workbook consists of 100 Data Entry &amp; 100 matched Data Sheets (Pivot Tables), with the Collected Data being summarized on 6 Team Sheets, 1 Floor Summary &amp; 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 &amp; 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 &amp; 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

Hello Sir,
Please send me the files and I can make free demo for you before you accept any bid.
Then you can decide.
I'm an excel programmer with 10 year of experience . Now I maintain large excel applications arunLagi

Hello,
Have much experience in finding and rooting out errors, in excel-based and visual basic applications. We have fully trained graduate-level peron and also Professional Engineer on staff.
Thank you for yourLagi

I am new to the GAF community, but I can tell that you don't need someone to do this fast. You need it done right. My time estimate is based on the information you've posted, and I believe that once we find the calcuLagi

Dear Sir,
I have 6 years experience about Excel or Data Entry and 5 years .Net(VB,C#.ASP)(VB,VC++, PhotoShop, HTML, Database Management System and other related S/ws). So, Hope I will have to complete your project.Lagi

Please visit our website www.calcul8ors.com.au to see examples of previous work we have done. We are a small consultancy based in Melbourne Australia with years of commercial experience.
Kind regards
Shail Akhil
CLagi