VBA macro to find data in different workbook then paste it into a new workbook
$10-30 USD
Paid on delivery
Hi,
I need someone to write a VBA macro to find data in different workbook then paste it into a new workbook in the format attached.
The workbook contain data from cricket matches and some knowledge of cricket would be an advantage.
I want to be able to type the name of a ground or create a dropdown menu (I haven’t decided) in a field then click a button to start the macro.
The workbooks containing the data are called [login to view URL] and BallByBall.csv.
[login to view URL] contains the following data for every match played at the ground:
Date (col D)
Start Time (col E)
Ground (called venue) (col O)
homeTeam (col P)
awayTeam (col Q)
Toss (col R)
Choice (col S)
Result (col U)
Matches also contains a unique ID for each match (matchId) in column A. This will be needed to lookup the data below in a workbook called BallByBall.csv.
For now I just want the following data for the first innings. This is denoted by a 1 column C.
Total Runs and Total Wkts can be found by looking for ball 120 in column D for the specific match then returning the values in column L (currentRuns) and column M (currentWkts).
If a team has been bowled out before ball 120 or the game has been shortened I need the Total Runs and Total Wkts as at the last ball of the innings. This means the macro will have to look for the highest ball number.
The total number of balls should also be pasted into the Balls column.
For 6 Ov Runs and 6 Ov Wkts I need currentRuns and currentWkts after ball 36.
Finally, I want the number of runs scored in each over. This isn’t listed specifically so the macro will need to subtract currentRuns at the end of the previous over from currentRuns at the end the over in question.
I have attached examples of the workbooks. The actual workbooks contain many thousands of rows.
If you have any questions please ask.
Thanks
Project ID: #21725791
About the project
Awarded to:
Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer and have done mostly Excel VBA Programming jobs. I have read your instructions carefully. I have excellent knowledge and experience of M More
25 freelancers are bidding on average $27 for this job
$ 15 Only ------ In just 6 Hours ------ Excel Workbook Link Generation, VBA Macro Coding and Formula Generation Expert ------ 100% satisfaction first, then payment.
HI, This data can be got using XL functions. Do you really want a Macro? I have the solution using only functions and it is perfect. If you are interested, send me a message and I will explain regards
Hi, I am Ibrahim and I am a data scientist, I can develop a MACRO for this purpose, I need to know, whether you want to do it on a push of a button, or do you want it automated? Regards, Ibrahim Anjum
Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. If interested,we can discuss this further on chat.
hi there, I am an excel expert. knows a lot about excel VBA and advanced formulas. I can complete your project most probably in just one day. waiting for your response
Hello si/madam, I have read your proposal. can start it now!! I have good knowledge and experience of excel. i can complete the work with higher accuracy.
Hi, I have 12+ years experience with MS excel and handled many complex scenarios using Excel Macros and formulas. Have gone through the description provided by you and downloaded and analyzed the sample workbooks share More
I have been a Excel Macro VBA developer for over 4 years. I have worked for the largest company in the PH, was a developer consultant for one of the biggest Tea Company in the philippines. In recent years, a great dea More
Hi, I have worked on similar Macros and have got a basic understanding of your requirements. I will go over the details and send over any queries I might have regarding the same. I am new to Freelancer and would be g More
I can this for a few hours. I have been working as a typist and developer with LabView, python, Java, office,MATLAB, vb, c, c++,web programs for 7+ years. In these years, I have many experiences in these branches.
Hi there. I am an expert user of Microsoft Excel and developed many decision support systems on Excel for big companies. I have considerable experience in macros and VBA. I looked up on the documents and I believe tha More
im vba macros for office specialist, ill do a great job for you in a short time, u'll get your macros within 4 days or less
Hi, I am an expert in Data Analysis and Excel and VBA. Also I play the game of cricket and would love to be involved in this project. I can have the solution completed for you in a couple of days, and can start right a More