mattadams84
Board Regular
- Joined
- Oct 30, 2016
- Messages
- 54
Hello,
I am looking to create a VBA script that will copy over data from a range of cells to another sheet. The scenario i have is a spreadsheet that collates football match results from across the world. I have a sheet named "Latest Results" and then two other sheets, "O1.5" and "O2.5" which have all the results collated since i started collecting data. Each evening i add the next days matches to each sheet and at the end of the day once the matches have been played I use a piece of software which populates the latest results sheet and then i manually copy the results to the other two pages. However what i would like to do is have a macro that checks if a match has a result on the latest result page, then i would like it to copy that result in to the corresponding cells on the other two pages and then delete it from the latest results page.
So, 1 match equals one row and there are 4 columns which contain the match data : date, league, home team, away team. There are then 7 columns which contain the result data. I guess the macro would need to look at each row (match) on the latest result page, see if it has a result, and if it does, see if that row exists on the other two pages. If this is true then it would copy the 7 columns of result data over to the other two pages and then delete the row from the latest result page.
This is an exteremely complicated request so if anyone can help me i would be grateful. I have attached a link to my spreadsheet so you can see it more clearly.
https://1drv.ms/x/s!Aqt6z2wNNUtZg9d5YtUKvQ-1zFb-LA
Kind regards
I am looking to create a VBA script that will copy over data from a range of cells to another sheet. The scenario i have is a spreadsheet that collates football match results from across the world. I have a sheet named "Latest Results" and then two other sheets, "O1.5" and "O2.5" which have all the results collated since i started collecting data. Each evening i add the next days matches to each sheet and at the end of the day once the matches have been played I use a piece of software which populates the latest results sheet and then i manually copy the results to the other two pages. However what i would like to do is have a macro that checks if a match has a result on the latest result page, then i would like it to copy that result in to the corresponding cells on the other two pages and then delete it from the latest results page.
So, 1 match equals one row and there are 4 columns which contain the match data : date, league, home team, away team. There are then 7 columns which contain the result data. I guess the macro would need to look at each row (match) on the latest result page, see if it has a result, and if it does, see if that row exists on the other two pages. If this is true then it would copy the 7 columns of result data over to the other two pages and then delete the row from the latest result page.
This is an exteremely complicated request so if anyone can help me i would be grateful. I have attached a link to my spreadsheet so you can see it more clearly.
https://1drv.ms/x/s!Aqt6z2wNNUtZg9d5YtUKvQ-1zFb-LA
Kind regards