I have a worksheet that records estimated hours to be spent on projects for various staff members along with the value of time spent on projects to date. Data is summarised on a couple of different worksheets.
Because the workbook sums data from the same cells across multiple worksheets and these cells can move around (continually adding and removing projects) the formulas are a little more complicated than usual. The main problem I am encountering is that the workbook is completed by people who are no sophisticated Excel users and I am finding that they are frequently overwriting formulas etc with incorrect data - despite me trying to have them protect the worksheets. So I am looking to either make the spreadsheet more user proof or alternatively, I kind of think it might lend itself to a Access database instead of using Excel.
The worksheet is attached and a few salient points are noted below:
1. Generally one staff member complete the sheet on a weekly basis by updating the list of projects (across the master project list and all individual staff sheets - of course, staff members come and go and the totals on the master sheet need to include all staff [url removed, login to view] cost spent to date is also entered at this time - this comes from another application where staff enter timesheets - it is a SQL database and being able to copy that data into this worksheet/database would be a big timesaver.
2. Then estimated hours per project per day for the coming week for each staff member are entered.
3. This is summarised into the Master Project List and the Designer Summary.
They are the main points but would need to discuss our needs in a little but more detail working through the workbook - overall I don't think it is that complex but I don't have time nor inclination to brush up on Access skills and Excel skills fall just a little short to improve this. Don't really have any idea how long the project will take so the budget I have indicated is a guess only - happy to work on hourly rate basis as well if I am comfortable twith who I am using.
29 freelancers are bidding on average $1017 for this job
I know officeBasic like the back of my hand and have written MS Access applications for entire workflows. I can convert this into a nice Ms Access application with necessary input forms and reports.
I am expert in excel , macros and access. I have built several complex applications using these. I would like to work with you. Please let me know further. Regards, Selvan
Hi, I can help you with your requirement. I have closed more than 150 excel projects at various forums. Please provide more details to help you better. Regards Sawan
Software developer since 2000, specializing in Visual Basic, SQL server, Crystal Reports/VBA for MS Office. I recommend using UserForms to minimize (if not totally eliminate) user errors