I have spreadsheet where I am looking to link two sheets together efficiently. I have a set of around 200 fixtures on one sheet laid out as follows:

A - Round
B - Home Team
C - Predicted Home Score (from a VLOOKUP on a different sheet)
D - Away Team
E - Predicted Away Score (from a VLOOKUP on a different sheet)

On any given row (in the case of this example 100 say), I am looking to take C100 and E100 and feed them into a POISSON formula on a separate sheet (named WORKINGS).

In this case on my probabilities worksheet I have H33 =(FIXTURES!C100) and I33 =(FIXTURES!E100). This feeds through a calculation, giving me H47, H48 and H49 that I want to feed back into the FIXTURES sheet.

Also on the workings sheet I have H51=H33+I33, which feeds through another calculation giving me H76 and H77 that I want to feed back into my FIXTURES sheet.

This is easy enough to do over one fixture, but I'm thinking what the tidiest way of doing this say for a couple of hundred fixtures?

I'm thinking I could make loads of copies of the original formula on the WORKINGS sheet, or would it be easier to do a Macro possibly for every row (and maybe put a WORKINGS worksheet in for every line?).

Any advice at all, would be appreciated.

Many thanks,