# Copy paste based on a condition

#### jay36429

##### New Member

Hi,

I have run into a problem which is quite unique. I have data for 40000 football matches. The Sheet "Raw data" has the raw format of the data.

Sheet "Goal Difference (Home - Away)" is pretty important. This sheet is the goal difference between the home team and the away team. "A5:A95" has the number of minutes in a football match and we are trying to track the way a team progresses throughout the match. Lets assume the score is 0-2 for the 1st match and the goals were scored in "39, 76," minute by the away team. So the data will read 0 from 0-38, -1 from 39-75 and -2 from 76-90.

Sheet "Red Cards conceeded_Home" tracks the number of red cards as the match progresses through 0-90 minutes for the home team. The catch here is if the score reads
Red Cards : "1 - 2" and the Red Cards Time reads "26, 15, 18". The red card was issued to the home team at 26th minute, The away team received it at the 15th and 18th minute. So the data will read 0 from 0-25, 1 from 26-90.

The same applies to the other tabs.

I have searched for this solution on my college forum and even the experts are finding it difficult. I cant attach the file here which makes it all the more difficult. I can mail you the file. Please help.

Last edited by a moderator:

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Hi. It's not clear which exact part of your problem you need help with.
You seem to have described what is currently happening with your data.
So what do you want to do differently ?

Replies
3
Views
531
Replies
26
Views
1K
Replies
9
Views
307
Replies
25
Views
2K
Replies
2
Views
177

1,203,071
Messages
6,053,369
Members
444,658
Latest member
lhollingsworth

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back