Using calculation template to populate multiple results

[indygo]

hi,

I will try my best to explain my problem.

Imagine in Sheet 2 you have various types of calculations. They take the entire page and are quite complex.
In Sheet 1 you have inputs for example Score A and Score B, which result in a computation in column E (from sheet2)

	a	b	c	d	e
1	Player A	Player B	Score A	Score B	Computation
2	John	Dave	1234	1000	2233
3	Michael	Donald	2500	2300	12.23
4	Rita	Kate	1500	1523	133

Because computation in sheet2 takes the entire page and it would require from me to create a copy of that sheet for each pair - is there a way to use Sheet 2 as a template/blueprint for all the other computations?
I'm sure there's some clever way to tell excel to follow this logic based on this sheet.

Thanks

 

[awoohaw]

So, column E is really mapped to a cell from Sheet2?
What are the calculations in the column in Sheet2. Are they all the same or different?

 

[indygo]

Sheet2 is taking inputs from column C&D and returning outcome in column E. Sheet2 can only calculate one matchup hence my post.
To get computation for other pairs I would have to either change manually cell reference or create copies of sheet2.

 

[indygo]

bump

 

[awoohaw]

As I read your question there still isn't enough information. I guess my question in Post 2 was not clear enough.
How are you using the values in column C & D in the calculation of sheet 2?