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
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 to make the entry of variables into a software tool I developed easier. VBA is a relatively simple language and I'll make every effort so you can understand and extend the code if you want.
Honestly, your budget is set too high. This project should be a matter of an hour or so.
Let me know if you're interested in working with me!
€30 EUR en 3 días
5,0 (1 comentario)
1,1
1,1
19 freelancers están ofertando un promedio de €73 EUR por este trabajo
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 regards
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 manually and i believe i can create this code for you really fast. As i said i m serious freelancer and i've never took a single dollar unless my solution was perfect.
Thanks, Milan
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 part of Excel Forum for years and currently at the post of Forum Expert at the same site. You can check out my portfolio for more details.
Believe me, I would provide the best quality work and cheapest prices of course.
Please contact me once. I won't disappoint you. Please do contact me :)
Regards
Sourabh Gupta
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.
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.
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.