| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO COPY A CELL BUT INCREASE ITS REFERENCE BY TWO CELL POSITIO.
I want to copy a cell that has a reference to a cell in another sheet but I
want the new reference to be incremented by 2 positions. example copy cell f1 to f2, cell f1 has a reference to 'test'!r5 I want the f2 cell to reference 'test'!r7 Can this be done? Thanks, no1crusty |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HOW DO COPY A CELL BUT INCREASE ITS REFERENCE BY TWO CELL POSITIO.
Hi
Try =INDIRECT("'Test'!R"&5+(ROW(A1)-ROW($A$1))*2) -- Regards Roger Govier "Crusty" wrote in message ... I want to copy a cell that has a reference to a cell in another sheet but I want the new reference to be incremented by 2 positions. example copy cell f1 to f2, cell f1 has a reference to 'test'!r5 I want the f2 cell to reference 'test'!r7 Can this be done? Thanks, no1crusty |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to reference/copy cell format ??? | Excel Discussion (Misc queries) | |||
| Using a cell reference to copy rows to a new worksheet | Excel Discussion (Misc queries) | |||
| How do I copy formatting in a cell reference | Excel Discussion (Misc queries) | |||
| how do you copy the same cell reference on different worksheets | Excel Worksheet Functions | |||
| increase a cell reference by increments greater than one... | Excel Worksheet Functions | |||
Linear Mode
