| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
do the same thing to multiple hard coded cells
Hello!
How can I repeat a function to multiple cells that are hard-coded with data? For example, I have the following data hard-coded: D ..... H 1 50 42 2 38 37 What I would like to do, is add what is in D1 to what is already hard-coded in H1 (in this case, 42 + 50, but I don't want to go back into every cell in column H and type in the "+D1"), and add D2 to what is in H2, etc. Any help is appreciated! Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Versatile "adaptive" formulae? (instead of "hard"coded IF tests) | Excel Discussion (Misc queries) | |||
| Changing the Same thing on multiple charts | Charts and Charting in Excel | |||
| Sum Color coded cells | Excel Worksheet Functions | |||
| Convert Hard-coded cell values to constants | Excel Discussion (Misc queries) | |||
| References to open/hidden workbooks become hard-coded in formulas - 2003 | Excel Discussion (Misc queries) | |||
Threaded Mode
