| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you change the relative reference of a cell in an Excel formul
I have a formula in cell K4 which includes a reference to the value in cell
H11. When I copy the formula to cell K5 Excel thinks that I then wish to refer to the value in H12. I would like to be able to copy the formula in K4 down a varying number of rows each time I do it and have the reference to cell H11 increase by 10 rows each time. For example the formula in K5 would refer to cell H21 and the one in K6 to H31 and so on. Is this possible in Excel? Many thanks - Rod |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Relative cell reference | Excel Discussion (Misc queries) | |||
| how do I change macro relative reference? no stop recording tool | Excel Discussion (Misc queries) | |||
| Relative Cell Reference | Excel Worksheet Functions | |||
| How do I change a cell from absolute reference to relative referen | Excel Discussion (Misc queries) | |||
| can you use a variable or cell reference in a getpivotdata formul. | Excel Worksheet Functions | |||
Threaded Mode
