In Progress

Make this excel spreadsheet work (errors in macros pivot table)

So I have an excel spreadsheet where in All Shifts I copy and paste in the shifts done for this month, and using pivot tables and lookups it checks the rates to pay out and to charge for each of my team, and in Final Contractors invoice To Me tab, it works out what I expect each contractor to invoice me.

Except it's not working right, there seem to be 2 errors;

1) All Shifts dates in All Sifts Column A and B don't seem to be copying correctly, it should be that the only dates are in October and November, yet when I look at Final COmpleted All Shifts and Final Contractors Invoice To Me, they make reference to shifts in June and May and others.

2) In the Rates tab I just added buy charged out rates and rates I pay into column E and K for a new category of Shadowing. So the formula in the All Shifts needs amending to pick up the data from the rates tab. You can see Shadowing as a service in All Shifts, for example Monitor: 1484606 in Row 94 shows it.

The job please is to correct both these issues, I estimate probably 1 hours work for you, the doc is attached.

I am online for the next 3 hours, and will choose the winning bid in the next 20 mins.

So often when I place a job on here, people autobid, so I will delete your bid if it does not start with the word ONION. If I don't see ONIOn, I will assume you didn't read this brief and delete your bid, no matter how good it is :)

Thanks in advance,

Good luck freelancers and happy bidding for my project!

Skills: Data Processing, Excel, Excel Macros

See more: excel spreadsheet work from home, excel macro import csv create pivot table, price excel spreadsheet work, excel 2010 pivot table project, excel spreadsheet work ipad, pivot table project excel, excel spreadsheet work, make excel spreadsheet, freelance excel spreadsheet work, excel spreadsheet work completed, contract excel spreadsheet work, convert excel spreadsheet work web page, excel web access aspnet open pivot table, excel spreadsheet work bank statement, vba excel spreadsheet work, create excel pivot table net, vsto pivot table excel

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

Project ID: #15682165

Awarded to:

Ashisjena2015

ONION. I can fix this problem within 30 minutes. Please message me. Thank you!...............................................................

$25 USD in 0 days
(13 Reviews)
3.7

8 freelancers are bidding on average $27 for this job

schoudhary1553

Hello Sir, I am the expert freelancer for Make this excel spreadsheet work job . i have deliver more than 250 projects with 100% client satisfaction. so please give me chance to work on your job. Relevant Skills and More

$60 USD in 1 day
(207 Reviews)
7.2
nurnga1218

Hi, I've read your project brief. I offers a completely new solution instead fix your error. I want to make it all over like new with macro VBA, I think it will be easier for you to use it. Relevant Skills and Experie More

$30 USD in 3 days
(30 Reviews)
4.3
mhfsha

ONION I just check the description would be a pleasure to assist you on your project. looking forward to discuss in the chat.

$10 USD in 1 day
(14 Reviews)
3.6
dayakmlt

Onion Relevant Skills and Experience Excel Proposed Milestones $20 USD - Excel

$20 USD in 1 day
(13 Reviews)
3.4
MechChama

ONION Let handle your works to professionals. I can guarantee that 100% accuracy and quick completion of work. Thanks... Relevant Skills and Experience Excel, Data Processing Proposed Milestones $22 USD - Total

$22 USD in 1 day
(4 Reviews)
2.5
haleem0786

ONINE ...I have good command over MS Excel especially povit table, charts, advance formulas etc. do let me know more detail in PM. thanks

$25 USD in 1 day
(5 Reviews)
2.2
imdadulislam1886

I can do this right now, I have plenty of time and ready to do it. Relevant Skills and Experience Data Processing, Excel, Excel Macros thanks Relevant Skills and Experience Data Processing, Excel, Excel Macros Propo More

$21 USD in 1 day
(0 Reviews)
0.0