Completed

Do some Excel Work

Hi!

I would like need next thing. In the uploaded excel file there are 2 sheets.

I would need simple code, that would copy some values from one cell to another everytime a value in particular cell is changed, but everytime it would be copied in another cell, so I would have all values in new sheet.

I have in sheet 1 (MATCH) stats of live tennis match. I have data about live score (sets,games,points), who is serving and live odds for match winner for both players.

I would then need that every point would be threat as own unit (sheet 2, DATA), so that after every point (after every change of cells B5 or C5 in sheet MATCH), new "unit" in sheet DATA would be created, withd the variables as named in sheet DATA (A1:R1).

Most of variables in sheet DATA would have just copied value from sheet MATCH, only a bit different would be variable W (point winner) and S (sever), which would need additional if sentence.

I believe it isn't complicated, but I have no experiance with vba, so I don't even know how to start writing a code. I even don't need code for all variables, only maybe for 1 that is only copied (I can make for all others I guess) and for W and S variables maybe.

I don't have idea how much of work would you need for this and also how much would it cost, so you can also write me message on chat to talk about my project.

I hope I also give you understandable instructions.

Thank you!

Nejc

Skills: Data Entry, Data Processing, Excel, Programming, Sports

See more: work values, the w games, guess who sheets, excel live chat, macros work excel internet, excel plotting sets data different axis, macro dont work excel 2000, freelance work excel vba, track work excel, macros written excel 2000 work excel 2007, contract work excel access, excel 2000 macros work excel 2007, article submission work excel, show project work excel, work excel file, contract work excel, online contract work excel, data entry work excel, work excel database, surf internet work excel

About the Employer:
( 4 reviews ) Petrovče, Slovenia

Project ID: #10999425

Awarded to:

mariusoei

Hi! I understand you need VBA macro that mostly copies values from one sheet to another (into a new line every time) when you change the score in the first sheet. In my time at Bosch, I have used VBA macros in Excel More

€30 EUR in 3 days
(1 Review)
1.1

20 freelancers are bidding on average €71 for this job

cgullapalli

Hi, I am good at Excel and vba. Looking forward to work on this project and discuss further.. I love tennis. Happy to work on this game.

€50 EUR in 0 days
(674 Reviews)
7.7
P0L

€50 EUR in 1 day
(257 Reviews)
7.0
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega More

€50 EUR in 0 days
(187 Reviews)
6.7
MimiFL

Hi, i m serious freelancer with 100% completion rate and i believe i can help you. I've done hundreds of vba projects and i've never had a single problem. If you are interested pm me so we can go over few examples manu More

€30 EUR in 1 day
(355 Reviews)
6.6
redouaneaberdin

Hi there, My name is Redouane. I am very interested in your project. Kindly start messaging so we can discuss further details. Thank you

€100 EUR in 3 days
(128 Reviews)
6.3
€30 EUR in 1 day
(53 Reviews)
5.5
nwss1986

Hi.I read your [login to view URL] is not that much complicated, though it involves some logic.i can do your job in a day, and can start right now.i have been in this field of vba for more than 10 years and have experience in codi More

€30 EUR in 0 days
(68 Reviews)
5.1
sourabhg98

Hello, Greetings for the day!! I read your description stating that you need some VBA code for your excel sheet. Sir, I am really looking for these kind of projects. I am an advanced VBA programmer. I have been a More

€30 EUR in 1 day
(41 Reviews)
4.6
€34 EUR in 1 day
(14 Reviews)
4.2
€100 EUR in 0 days
(10 Reviews)
4.1
VolKa

Hi. I am sure I will be able to do this. Regards..........................................................

€60 EUR in 3 days
(8 Reviews)
3.9
wasifmustafa

Hi. I have completed the project based on your requirements. Kindly review the link attached and it automatically copies the cells once the score changes. If you want we can adapt it any way you want. https://dri More

€60 EUR in 1 day
(3 Reviews)
2.4
sisodiadilip

I have worked earlier on data manipulation using vba script for spreadsheet data. I have created scripts to generate reporting summary for my team. I have good experience working on VBA.

€123 EUR in 5 days
(0 Reviews)
0.0
PhantomX1a

Full completion of agreed activity

€50 EUR in 2 days
(0 Reviews)
0.0
Basthian105

I 'll try to work on the problems you face

€166 EUR in 3 days
(0 Reviews)
0.0
DinSenin

---------------------------------------------------------------------------------------------------------------------

€155 EUR in 10 days
(0 Reviews)
0.0
leonardovitullo

I made many excel macros. I made them to allow generation of code and interaction with the user. So in my work i performed tasks more difficult than this.

€88 EUR in 3 days
(0 Reviews)
0.0
AndriaAquino

A proposal has not yet been provided

€155 EUR in 3 days
(0 Reviews)
0.0
SPB11

Have done similar stuff at work, will deliver as promised. I'm new here, please support. Will finish within 2days. I don't want to give a fake deadline.

€30 EUR in 2 days
(0 Reviews)
0.0