Reference Separate Sheet for Formula

[jeffrey]

I have sheets called Data and Formula.

On the Data sheet, I have three columns: Age, Height, and Score. Age
and Height columns are populated with numbers, Score is empty.
On the Formula sheet, there are cells where you type in Age and
Height, and an output cell with Score.
I would like to have a formula or macro that automatically enters
every Age/Height from the Data sheet into the Formula sheet and record
the Score on the Data sheet.

Jeffrey

 

[GS]

jeffrey expressed precisely :

I have sheets called Data and Formula.

On the Data sheet, I have three columns: Age, Height, and Score. Age
and Height columns are populated with numbers, Score is empty.
On the Formula sheet, there are cells where you type in Age and
Height, and an output cell with Score.
I would like to have a formula or macro that automatically enters
every Age/Height from the Data sheet into the Formula sheet and record
the Score on the Data sheet.

Jeffrey

Why not just put the formula that's used on 'Formula' in the 'Score'
column on 'Data' so it refs the inputs directly instead of having to
type anything on another sheet?

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Jeffrey Joh]

I have many cells of formulas that lead to the Score on the Formula
Sheet. It would be very cumbersome to recreate that directly on the
Data sheet.

Jeffrey