Automatic copy of values from one sheet to other sheets

**Frekazoid** · 08-09-2013, 05:33 PM

Hello,

I am trying to make some sheets with football teams from one championship and their results. For example i will have a match between TeamA vs. TeamB that will end 0-0. I will enter this value in the sheet for the TeamA results but normally this value will also be found in the results sheet of TeamB.

My question is, how can i make excel copy this value once i enter it for TeamA in the results sheet for TeamB.

Hope my question was clear, if not i will try to give some extras.

Thanks in advance!

**FDibbins** · 08-09-2013, 05:42 PM

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

**Frekazoid** · 08-09-2013, 05:51 PM

Thanks for the quick reply. I've attached a copy with less inputs of what i'm trying to do.

So, in the sheet "Team 1" on line 2 i have a game between Team1 and Team2 with the score being 1-1, the format is text for the score cells. I would like to know how can i tell excel to enter this "1-1" value, after i enter it manually in sheet "Team1", in sheet "Team 2" on line 2 where the same game is noted.

Thanks in advance!