Correct this excel workbook / spreadsheet so it all works
£20-250 GBP
Paid on delivery
I hope you can help here, I think this might need a bit of back and forth, but perhaps not, depends on how well you can follow this thread.
We have a spreadsheet in excel I am sent on request, that I then copy and paste the details into this attached worksheet.
I use this to then separate out what each contractor did and send to each one so they can see what they should be invoicing us for. They then reply yes that’s correct or let me know if they did overtime, or if we had an error. Instead I want them to be able to change what needs changing and send back so I can update this end.
The resulting updates let me send revised hours to each contractor using Final Contractors Invoice To Me Tab.
When it works, this is very useful, but it has a few quirks. And it can be improved too. The job here is to do both. You will need to review the attachments to understand this I full.
Because it can get confusing as the contractors send in invoices, and the client get invoices from this, I will refer to them as contractors invoice and client invoice.
So, contractors get their contractor invoices to check, and when all are approved the all Shifts tab is updated and amended, then the client invoices are created.
Attached are:
1. This specification for getting the new spreadsheet [login to view URL]
2. an excel workbook, called example of spreadsheet for [login to view URL]
3. An email I sent to a contractor to check their hours, it has embedded in it their hours to check, called Gmail - example email thread for contractor to check their [login to view URL]
4. An email I sent to an invoice team to check their team’s hours, it has a spreadsheet attached for them to check. This was made manually. The email is not included here but the spreadsheet is its called an example of a spreadsheet for an invoice [login to view URL]
5. An invoice for all the contractors on the SW Invoice – [login to view URL]
6. An invoice for a contractor not on the SW invoice – [login to view URL]
The rest of the specification is in the attachment.
Project ID: #18090340
About the project
56 freelancers are bidding on average £146 for this job
Hello, Hope you are doing well. I can help with you in your project Correct excel workbook / spreadsheet. I can assure you the quality job. I have good experience in Data Processing, Excel, Microsoft Office. W More
Hi there, I can correct this excel workbook / spreadsheet so it all works. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir
Hello client I would like to discuss the project requirements with you. I believe I can help you in this project. Kindly contact me. Roy
Hello, My name is Chrys. As you can see from my profile, I have 18+ years experience working with Excel/VBA and 14 years teaching them both (all levels). I can certainly do excellent work with your project. Please c More
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months. Ok. Sure. Willing to take up your project. Thank you, Regards.
I am a professional accountant with a decade of experience working in a US based NASDAQ registered company's finance department with excellent excel skills and knowledge.
Sir,. I am very much able to work on this. ***I am ready to start Waiting to hear from you. with thanks and regards Relevant Skills and Experience Data entry, excel
hello sir ! How are you? i can do this job as per you requirements , just talk then we able to start work, regards
"cabbage" hello! Let me do it for you. I have read the specifications but I have to read it again to fully grasp the flow or the system you have but I understand the over all requirement. I am new here but please do More
cabbage I can do the job! I think the it's not so complicated (I ran through instruction, if awarded I'd tackle details), Probably would need some back and forth (chat or call through freelancer). I'm an engineer wit More
Greetings Scott, I read your complete project and also the file name specification for getting new spreadsheet and here is your keyword "cabbage" As per my understanding after going through the project you need an ex More
Hi, I have gone through the job description and become very much interested to work on it, can we discuss more over chat, please? Thanks
I am highly proficient in Excel and can create or modify any Excel sheets and produce a good outcome. I am recently retired after being the Head of IT for a major fashion retailer and am looking for new challenges t More
Sir/Madam, Greetings! This job captured my interest. I have read the job description and for sure I can handle the task. I have excellent communication skills and can follow instructions pretty easily. I am More
Respected Sir/Madam I have read the job details and is willing to work under your budget. I also see the attachments and trying to figure out your point. Sir , I will contact each contractor via emails and wri More
Dear Sir, I read your project description and would like to take part of it. Although I have completed few projects you can keep trust on me. I'll make sure to deliver your intended output and assure ti support in fut More
