Hello guys, hope you are all well.
Was just wondering if someone could maybe help me on this problem I have encountered on Excel.
I basically have a sheet that runs my calculations for my betting model. On another sheet I have the data that I input by hand into my model.
I have 2 parts of the model, one for the home team and one for the away.
I was wondering what the easiest way would be to automate this data entry process.
I have managed to create a drop down list for the home and away sides with all the team names and ideally I would be able to select the teams and the relevant data is filled in. However, I am unsure of how to do this.
Any help would be greatly appreciated.
Thanks very much
Was just wondering if someone could maybe help me on this problem I have encountered on Excel.
I basically have a sheet that runs my calculations for my betting model. On another sheet I have the data that I input by hand into my model.
I have 2 parts of the model, one for the home team and one for the away.
I was wondering what the easiest way would be to automate this data entry process.
I have managed to create a drop down list for the home and away sides with all the team names and ideally I would be able to select the teams and the relevant data is filled in. However, I am unsure of how to do this.
Any help would be greatly appreciated.
Thanks very much