Possible VBA to remove text from cell below and move it to row above.

Hi

Sorry if I dont explain it properly.

I copy and paste football statistics. I have attached a file to show how they paste. I would like it so that Both teams from each individual game have all the stats on the same row. At the moment the home team is on row 3 and the away team on row 3 etc.

The attached file shows in red which cells I want moved and the yellow show where I want them moved to, based on whether a condition is met. the condition is if the row above has a time in column B.

if any more information is required please let me know.

thanks in advance
Gemma

Try:

Please Login or Register  to view this content.

You are very welcome.