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.
20 freelancers are bidding on average €71 for this job
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.
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.