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

已完成 已发布的 6 年前 货到付款
已完成 货到付款

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!

数据处理 Excel Excel Macros

项目ID: #15682165

关于项目

8个方案 远程项目 活跃的6 年前

授予:

Ashisjena2015

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

$25 USD 在0天内
(13条评论)
3.7

有8名威客正在参与此工作的竞标,均价$27/小时

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 更多

$60USD 在1天里
(207条评论)
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 更多

$30 USD 在3天内
(30条评论)
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.

$10USD 在1天里
(14条评论)
3.6
dayakmlt

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

$20USD 在1天里
(13条评论)
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

$22USD 在1天里
(4条评论)
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

$25USD 在1天里
(5条评论)
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 更多

$21USD 在1天里
(0条评论)
0.0