hy , excel for match stats and scors

[thmh]

I'am new in excel and english is not my nativ langue,
exampl is in attachment .

sheet1:
is it posibil when entering ratio data befor match in team grid(dark blue) to calculated whit formula or macro to copy value to ratio grid(left) in matching row, if ratio is 5-1(I2) to copy it to row 4(B3) in grid , if ratio is 2-3 to copy it to row -1(B8) ... when is more same ratio to copy them to frst free cell in same row , when after match enter scor valu to copy valu in scor grid(right) in mirrored cell .
team grid is shortened with 5 team out of 20
sheet2:
ratio grid and scor grid are copied , in betven is mirrored match grid with copied first three leters of the team playing from team grid .

after all match are played in sheet1 ratio and score data(light blue) is clered and sheet2 is genereted new for next round(sheet3,4,5...) of match up to end of season.

I'am doing this manual it will bi great if it's posibl by formula or macro ,sory for my bad english.

[mdmackillop]

Can you post your workbook. Use Manage Attachments in the Go Advanced reply section.