I have a work book which helps keep track of football ratings for me. It is my challenge to try and automate a lot of the updating of the 'running rating' sheet. At the moment I manually update so looking for some help. The first piece is about moving info from the fixtures sheet to the ratings sheet.
The info I need is in the fixtures worksheet and the info to move/copy for the home team is in column V and the away team in column W. The home team is column G and the away team is column H.
I need to transfer the values in columns V & W to another worksheet called power. Now this is where the problems are:
all teams are only listed in column B, and the scores for the relevant dates are then in cells C through to BA. I then need to keep that rating so that I can track the teams performance, ie it can not be over written.
Can this be automated with a macro?
Appreciate any help/assistance anybody could provide.
Thanks
Taff
The info I need is in the fixtures worksheet and the info to move/copy for the home team is in column V and the away team in column W. The home team is column G and the away team is column H.
I need to transfer the values in columns V & W to another worksheet called power. Now this is where the problems are:
all teams are only listed in column B, and the scores for the relevant dates are then in cells C through to BA. I then need to keep that rating so that I can track the teams performance, ie it can not be over written.
Can this be automated with a macro?
Appreciate any help/assistance anybody could provide.
Thanks
Taff
