VBA Macro for Excel
$2-8 AUD / time
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
Prosjekt-ID: #22622047
Om prosjektet
33 frilansere byr i gjennomsnitt $7/time for denne jobben
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 Mer
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
$ 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% Mer
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 Mer
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 Mer
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 Mer
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. Mer
Dear, I have 15+ years of experience in excel. And I'm familiar to VBA. Let's discuss details over chat. Thank you.
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!
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 Mer
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 Mer
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
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.
Hi Client. I did the same for one of my client .i wrote macro for him and genrate excel as well as copy sheets.I can show demo if needed. I am the expert of writing macros in excel. You plz see the demo first then Mer
Hi There, I have 10 years of professional experience in VBA and Data Analysis.I can create the right tool which would help you out doing this by clicking just one button. I can get this done for a one-off project fe Mer
Hello there. I have seen your requirements, and I'm interested in this project. I'm an experienced content creator, Data Entry Operator, and Typist. I have years of knowledge and experience with me, which makes me th Mer