Reference Separate Sheet for Formula


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
 
Ad

Advertisements

G

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
 
Ad

Advertisements

J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top