| 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 |
| 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 | |||
Threaded Mode
