| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference Separate Sheet for Formula
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Reference Separate Sheet for Formula
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Reference Separate Sheet for Formula
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 On Apr 11, 6:38*am, GS wrote: 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 athttp://www.eternal-september.org ClassicVB Users Regroup! * * comp.lang.basic.visual.misc * * microsoft.public.vb.general.discussion |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sheet Reference in Formula | Excel Discussion (Misc queries) | |||
| Loop for formula on one sheet with reference from another sheet | Excel Programming | |||
| create a formula in one sheet that would read data from separate sheet automatically | Excel Discussion (Misc queries) | |||
| Change scales from reference cells value for a chart in a separate sheet | Charts and Charting in Excel | |||
| vlookup formula not working with data on separate sheet | Excel Worksheet Functions | |||
Hybrid Mode
