Reference Separate Sheet for Formula

  • Thread starter Thread starter jeffrey
  • Start date Start date
J

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
 
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
Click to expand...

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
 
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
 
Back
Top