Automating Excel spreadsheet
$30-50 USD
Paid on delivery
I have an excel spreadsheet that I enter hours for each employee, subdivided by client. (One employee can work with multiple clients, and each client can have multiple employees working with them).
Then on another spreadsheet I have to reenter the hours each client received. --I need this to be done automatically when I enter it the first time on each employee. --And put it in the correct space.
I enter mileage multiple times also in a similar way since each employee must be paid for the total miles but it has to be charged to the client.
I need to be able to add employees and clients into the spreadsheet. Therefore the formulas must be tied to the employee name rather than their spreadsheet location.
Interested freelancers must submit a sample of excel spreadsheet where you did similar work. This will help me Identify that you realize what I need.
Project ID: #2342765
About the project
Awarded to:
Such jobs are my daily practice. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of b More
28 freelancers are bidding on average $48 for this job
We are a team of 2 having vast experience in excel VBA scripting. Looking forward to work with you. thanks !! Please refer PMB for more details.
We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.
Hi, I have worked on conversion, manipulation and analysis of Excel for 20 years and have completed several freelancer projects, PLEASE CHECK FEEDBACK. Example in PM. I am UK based, on GMT time, available on skype and More
Hi, I have a 100% completion rate and would love to provide you with a WORKING SAMPLE before bid acceptance. Please refer PM.
Please check the personal message and attached file. It's already done. If satisfied then let's start.
Checklist of qualification: Prioritize this project; Advance Excel Skills- able to work in the VB atmosphere, create my own Macros for this job and very good in deriving the formulas needed to rack up the necessary out More