Đã hoàn thành

VBA Macro for Excel

Macros for Excel Spreadsheet

On Champion Data Sheet

Delete Column B

Delete Columns G to Q

Insert formula =ROUND(F2,1) into Column G

Insert formula =ROUND(G2,1) into Column H

Copy Down

Copy both Columns and Paste Value into Columns E and F

Delete Columns G and H

Remove Spaces in Column B using Replace

Insert Column before Column E

Insert Formula =B2&C2&D2 and Copy Down

Copy Column D and Paste Values into Column A

Data Sort Race ID and TN

Copy and Paste Champion Sheet to Columns A to G on PRICES sheet

Part 2

Copy Columns H to X and Paste as Values

Remove Spaces in Column H

Insert formula into Column I (Corrected Formula)

=IF(ISNA(VLOOKUP($H$2:$H$1085,$B$1:$G$778,COLUMNS($H2:I2),0)),"",VLOOKUP($H$2:$H$1085,$B$1:$G$778,COLUMNS($H2:I2),0))

Copy across and then Down

Insert 2 Columns before Column W

Insert 2 Columns before Column Z

Insert =L2 into Column W

Enter Formula =SUM(V2:W2) into Column X

Insert =M2 into Column Z

Enter Formula =Z2-Y2 into Column AA

if there is a Formula that deletes the #VALUE error please use.

Copy Sheet and Paste as Values

Delete Columns A to P and Columns S and T

Data Sort

RACE ID small to large

BS large to small

Insert Column before Column F

Enter Formula =G2-G3

Column T

Enter Formula =IF(N2=1,10,0)

Column U

Enter Formula =IF(R2=1,T2*J2,0)

Column V

Enter Formula =U2-T2

Column W

Enter Formula =W1+V2

Column X

Enter Formula =IF(O2=1,10,0)

Column Y

Enter Formula =IF(S2=1,X2*M2,0)

Column Z

Enter Formula =Y2-X2

Column AA

Enter Formula =AA1+Z2

Column AB

Enter Formula =IF(P2=1,10,0)

Column AC

Enter Formula =J2-1

Column AD

Enter Formula =IF(R2=1,"LL","LW")

Column AE

Enter Formula =IF(R2=1,0,AB2)

Column AF

Enter Formula =IF(R2=1,-AC2,0)

Column AG

Enter Formula =AG1+AD2+AF2

Column AH

Enter Formula =IF(Q2=1,10,0)

Column AI

Enter Formula =M2-1

Column AJ

Enter Formula =IF(S2=1,"LL","LW")

Column AK

Enter Formula =IF(S2=1,0,AH2)

Column AL

Enter Formula =IF(S2=1,-AI2,0)

Column AM

Enter Formula =AM1+AJ2+AL2

Conditional Formatting

Column A

equal to 1 Red

equal to 2 Yellow

equal to 3 Green

equal to 5 Red

equal to 6 Yellow

equal to 7 Green

equal to 9 Red

Column F

Greater than 3.99 Green

Column G

Greater than 96.9 Green

Less than 89.9 Red

Column G

Greater than 64.9 Green

Less than 44.9 Red

Column L

Less than 2 Green

Between 2 and 4 Yellow

Greater than 4 Red

Column M

Less than 4.01 Yellow

Between 4 and 8 Red

Column N

Greater than 0 Green

Column O

Greater than 0 Yellow

Column P

Greater than 0 1 Red

Column Q

Greater than 0 Yellow

Column R

Greater than 0 Green

Column S

Greater than 0 Yellow

Column T

Greater than 0 Green

Column U

Greater than 0 Yellow

Column V

Greater than 0 Green

Less than 0 Red

Column W

Greater than 0 Green

Less than 0 Red

Column X

Greater than 0 Yellow

Column Y

Greater than 0 Yellow

Column Z

Greater than 0 Green

Less than 0 Red

Column AA

Greater than 0 Green

Less than 0 Red

Column AB

Greater than 0 Red

Column AC

Greater than 0 Yellow

Column AD

Equal LW Green

Column AE

Greater than 0 Green

Column AF

Less than 0 Red

Column AG

Greater than 0 Green

Less than 0 Red

Column AH

Greater than 0 Red

Column AI

Greater than 0 Yellow

Column AJ

Equal LW Green

Column AK

Greater than 0 Green

Column AL

Less than 0 Red

Column AM

Greater than 0 Green

Less than 0 Red

Kĩ năng: Excel, Visual Basic, Xử lí dữ liệu, Visual Basic cho Ứng dụng, Nhập liệu

Xem nhiều hơn: vba macro excel unicode, excel 2003 paste clipboard vba macro excel, vba macro excel display contents, vba macro excel enable paste protected sheet, pre written vba macro excel, free vba macro excel stocks, vba macro install macros, vba macro excel freelancer, vba macro excel googlefinance, vba macro excel text file, vba macro excel update inventory pricing, convert vba macro excel menu item, need someone write vba macro excel, small script vba macro excel, bank reconciliation vba macro excel, vba macro excel gui, VBA/macro, excel automation

Về Bên Thuê:
( 23 nhận xét ) Tugun, Australia

ID dự án: #22622047

Được trao cho:

viveksr

I have got 9 years of experience in using and handling excel documents as pat of my job( Software Engineer) . I have got good understanding of Vlookup, Very strong with all kind of excel formulas which includes some o Thêm

$2 AUD / giờ
(0 Đánh Giá)
0.0

36 freelancer đang chào giá trung bình $7/giờ cho công việc này

schoudhary1553

Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without cha Thêm

$12 AUD / giờ
(360 Nhận xét)
8.0
TonmoyRoy111

Dear client I am an excel expert and I have previously carried out a number of projects in excel in the past using macros and formulas. I understand the scope of work involved in the project. I can definitely help yo Thêm

$10 AUD / giờ
(360 Nhận xét)
6.9
elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. Contact me to discuss the details. Best regards

$10 AUD / giờ
(246 Nhận xét)
7.0
sonarkaushik

Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I am very much able to work on this. ***I am ready to start Message me for further discussion. Waiting to hear from you. Thêm

$6 AUD / giờ
(103 Nhận xét)
6.2
vsprybhanu

Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating and Exchanging Data in Multiple Sheets Thêm

$8 AUD / giờ
(99 Nhận xét)
5.7
finecodervw

Hi, Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word, MS PowerPoint, MS Outlook automation. I have done good amount of work in VBA. It includes, extracting informati Thêm

$10 AUD / giờ
(88 Nhận xét)
5.8
selopezr

Hello! I'd be pleased to take care of your project. As per your description it can be done in less than one hour. Looking forwards to receive news from you! Shamy López Relevant Skills and Experience Experienced Exce Thêm

$8 AUD / giờ
(29 Nhận xét)
4.9
Ahmed818

Hello, ⭐⭐⭐⭐⭐ i am expert in this kind of jobs samples of my excel VBA jobs ⭐⭐⭐⭐⭐ https://www.freelancer.com/projects/excel/Create-Excel-Spreadsheet-Macro-that/ https://www.freelancer.com/projects/excel/Make-VBA-code-r Thêm

$2 AUD / giờ
(63 Nhận xét)
4.6
AnowarRatul

$ 2 AUD Only ------- In just 6 Hours ------- Excel VBA Macro Coding, Formula Generation and Automation Expert------ I have done this type of project before and I can compete the project absolutely as you want with 100% Thêm

$2 AUD / giờ
(61 Nhận xét)
4.7
writingapp

Hi. I am ready to write your project Write apps on your demand in many languages (Visual Basic, VBA, VBS, .NET, C#, JS, Python, Java, PowerShell) Write database apps including many db formats: MS Access, MS SQL, SQL Thêm

$5 AUD / giờ
(31 Nhận xét)
4.9
Bobkov

Dear, I have 15+ years of experience in excel. And I'm familiar to VBA. Let's discuss details over chat. Thank you.

$15 AUD / giờ
(7 Nhận xét)
3.8
developerguru15

Hello, I'm a guru in excel spreadsheet. I'm also a developer with more than 5 years experienced. I can help you on this. Please contact me now. Thank you!

$5 AUD / giờ
(3 Nhận xét)
3.5
ravinderkumar248

Hi there, I read your requirements and understand very-well and ready to start work from now. Hope you give me a chance to do work with you. I hope you will be kind enough to consider me for your [login to view URL] forw Thêm

$5 AUD / giờ
(9 Nhận xét)
3.3
eduuardo

I suggest a one click magic button as a permanent tool that will at one click process data on the fly, create and extend relevant formulas and aply conditional formating to destination cells. Fixed price 100 AUD. 13 y Thêm

$10 AUD / giờ
(12 Nhận xét)
3.3
khaldalfalah

Hi, I am ready to work on your excel file. I have experience in MS SQL server,asp.net, access, excel, crystal reports and VB.net more than 12 years. CV: I am software engineer, Holder of a degree in Faculty of Informa Thêm

$8 AUD / giờ
(7 Nhận xét)
2.9
parkheaven16

Dear Sir, I am a professional data entry writer with 5 years working experience about M/S Word, M/S Excel, Web Research, Data Analysis, Data Scarping, virtual assistant and Data Entry related activities. As per your j Thêm

$2 AUD / giờ
(2 Nhận xét)
3.1
Alexsfodik

Hello. How are you. I'm software engineer and algorithm expert. I have many experiences in Access, Excel, VBA. I can complete your project successfully. Thanks.

$15 AUD / giờ
(2 Nhận xét)
2.2
Bsram88

Hi I can develop excel VBA macro for the above logic. I have made such strategies already for some stock market projects so i can finish this task within 4 hours. I can show you my recent projects if you want to see. T Thêm

$8 AUD / giờ
(2 Nhận xét)
1.5
habibadmd

I have thoroughly read your post. I think I'm the best at this job. I have enthusiasm towards doing this work please give me a chance to prove my talent through this opportunity

$2 AUD / giờ
(2 Nhận xét)
1.1
sheltonates

Hello. I have read your request and it is very simple. I can have this completed within 24 hours or less. I am an Excel Expert with over 20 years experience. Thank you for your consideration.

$6 AUD / giờ
(1 Nhận xét)
0.4