Completed

Correct this excel workbook / spreadsheet so it all works

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.

Skills: Data Processing, Excel, Microsoft Office

See more: excel workbook software, convert excel workbook windows application, excel stock spreadsheet, convert excel workbook, convert excel workbook stand alone application, advanced excel mortgage spreadsheet, convert excel workbook standalone, data excel workbook master workbook using vba, convert excel workbook visual basic, soccer excel blank spreadsheet league, upload excel workbook turbolister, port excel vba spreadsheet website, excel workbook update service, eplain excel budget spreadsheet stock symbols, convert excel workbook stand alone program, excel workbook packaged standalone software, excel workbook project tracker, lock excel workbook, bbb review excel budget spreadsheet, excel summary spreadsheet workbook 2010

About the Employer:
( 297 reviews ) Braintree, United Kingdom

Project ID: #18090340

Awarded to:

sysdesigner13

Hi, bro! I've read your requirement. I have rich experience with data processing in Excel. I have finished many projects like this. I'm confident in your project and I promise to do your project in time. Hope y More

£100 GBP in 3 days
(9 Reviews)
3.7

61 freelancers are bidding on average £143 for this job

schoudhary1553

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

£150 GBP in 2 days
(289 Reviews)
7.7
mirniyazuddin92

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

£100 GBP in 3 days
(296 Reviews)
7.7
dgled

Hi, I can help you to improve and automate the process. I am a financial expert and guru in Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application includ More

£250 GBP in 3 days
(68 Reviews)
6.8
paris2785

Hello, Scott (cabbage)! I am Paris and just had the chance to read your project's (long, but detailed) brief. I get that you are looking for an Excel developer that will adjust your Excel spreadsheet to fulfill your More

£250 GBP in 7 days
(158 Reviews)
6.8
chriskerpini

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

£250 GBP in 5 days
(75 Reviews)
6.7
zekovicm

Hi there,I am Miljan,Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the ag More

£177 GBP in 2 days
(96 Reviews)
6.9
TonmoyRoy111

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

£200 GBP in 3 days
(282 Reviews)
6.6
periyannas

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.

£250 GBP in 10 days
(68 Reviews)
5.8
sonarkaushik

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

£150 GBP in 3 days
(52 Reviews)
5.8
choprac

Hello, Hope you are doing good, I read the job description. It’s my kind of work. I can complete the project timely and within your budget. I am an MBA having an advanced knowledge of Internet research, Video / Audi More

£115 GBP in 3 days
(98 Reviews)
5.5
Orientwork

hello sir ! How are you? i can do this job as per you requirements , just talk then we able to start work, regards

£50 GBP in 3 days
(59 Reviews)
5.0
c4cuteconain

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.

£50 GBP in 3 days
(39 Reviews)
5.0
sevillajk01

"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

£200 GBP in 10 days
(15 Reviews)
4.0
michael767

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

£150 GBP in 3 days
(2 Reviews)
3.4
jalik20

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

£135 GBP in 7 days
(17 Reviews)
3.5
developerguru15

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

£150 GBP in 3 days
(2 Reviews)
3.3
nishantha041

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

£45 GBP in 3 days
(4 Reviews)
2.9
abhaymshr091

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

£150 GBP in 3 days
(8 Reviews)
2.9
julietpham

I am able to do it. and commit that I will complete it on time. And I sure that you found a new freelancer but strong experience and will offer good price. Thank you!

£150 GBP in 2 days
(4 Reviews)
1.2
ielucerotrad1

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

£110 GBP in 4 days
(1 Review)
1.4