Correct this excel workbook / spreadsheet so it all works

Sedang Disiapkan Disiarkan 5 tahun lepas Dibayar semasa penghantaran
Sedang Disiapkan Dibayar semasa penghantaran

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.

Pemprosesan Data Excel Microsoft Office

ID Projek: #18090340

Tentang projek

56 cadangan Projek jarak jauh Aktif 5 tahun lepas

56 pekerja bebas membida secara purata £146 untuk pekerjaan ini

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 Lagi

£150 GBP dalam 2 hari
(326 Ulasan)
7.9
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 dalam 3 hari
(340 Ulasan)
7.9
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 Lagi

£250 GBP dalam 7 hari
(220 Ulasan)
7.4
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 dalam 3 hari
(347 Ulasan)
6.9
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 Lagi

£250 GBP dalam 3 hari
(88 Ulasan)
7.1
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 Lagi

£177 GBP dalam 2 hari
(124 Ulasan)
7.3
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 Lagi

£250 GBP dalam 5 hari
(76 Ulasan)
6.7
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 dalam 10 hari
(109 Ulasan)
6.3
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 dalam 3 hari
(71 Ulasan)
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 Lagi

£115 GBP dalam 3 hari
(98 Ulasan)
5.5
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 dalam 3 hari
(52 Ulasan)
5.7
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 dalam 3 hari
(63 Ulasan)
5.1
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 Lagi

£200 GBP dalam 10 hari
(30 Ulasan)
4.6
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 Lagi

£110 GBP dalam 4 hari
(18 Ulasan)
4.1
imfarrukh47

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 Lagi

£200 GBP dalam 3 hari
(9 Ulasan)
4.2
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 dalam 7 hari
(17 Ulasan)
3.5
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 Lagi

£150 GBP dalam 3 hari
(5 Ulasan)
3.6
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 Lagi

£150 GBP dalam 3 hari
(2 Ulasan)
3.3
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 Lagi

£150 GBP dalam 3 hari
(20 Ulasan)
3.6
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 Lagi

£45 GBP dalam 3 hari
(4 Ulasan)
2.9