VBA macro to find data in different workbook then paste it into a new workbook

Completed Posted 4 years ago Paid on delivery
Completed 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

Excel VBA Excel Software Development Excel Macros Visual Basic

Project ID: #21725791

About the project

25 proposals Remote project Active 4 years ago

Awarded to:

vsprybhanu

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

$30 USD in 1 day
(94 Reviews)
5.8

25 freelancers are bidding on average $27 for this job

AnowarRatul

$ 15 Only ------ In just 6 Hours ------ Excel Workbook Link Generation, VBA Macro Coding and Formula Generation Expert ------ 100% satisfaction first, then payment.

$15 USD in 1 day
(164 Reviews)
5.9
reubengi

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

$25 USD in 7 days
(19 Reviews)
4.9
ibrahimanjum330

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

$10 USD in 3 days
(10 Reviews)
4.7
MonisZafar

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.

$30 USD in 1 day
(19 Reviews)
4.4
wkcompany

Hi, I am ready to start right away. I'm an expert in Data Entry. I have reviewed your job description as well and very confident to handle this project perfectly. I understood your all requirements. I have done many p More

$30 USD in 1 day
(17 Reviews)
3.8
ravim211071

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

$15 USD in 2 days
(6 Reviews)
2.4
ArunTindu

Dear Client, From your job description, I understood the requirement you have been looking for as an output with a help of macro. The final expected output file clearly defines your expectation from the input. I can More

$30 USD in 1 day
(2 Reviews)
1.0
harshinipatil

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.

$15 USD in 5 days
(0 Reviews)
0.0
josechakkala

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

$30 USD in 4 days
(0 Reviews)
0.0
jayvillalobos686

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

$30 USD in 3 days
(0 Reviews)
0.0
shilpamanoj07

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

$30 USD in 2 days
(0 Reviews)
0.0
uxiaojuan2019

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.

$30 USD in 1 day
(0 Reviews)
0.0
emreberkunsal

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

$10 USD in 3 days
(2 Reviews)
0.0
devoo225

I can do that Relevant Skills and Experience Iam certificate holder of ms office

$25 USD in 3 days
(0 Reviews)
0.0
benrached46

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

$25 USD in 4 days
(0 Reviews)
0.0
bryanorsmond

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

$40 USD in 3 days
(0 Reviews)
0.0