Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
fill question
Hi,
I want to somehow automatically increment cell references. It would be easier to explain with an example. In my worksheet, i want to list all the all the summary turnovers in my Turnover worksheet. For the first cell, Turnover!D7 is what i want, Turnover!D14 is for the second cell, Turnover!D21 is for the third cell and etc. If i use the normally fill function by holding right corner and dragging i will get Turnover!D8 for second cell, Turnover!D9 for third cell and etc. Could someone enlighten me. It is so frustrating to always add 7 to the previous cell reference. Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
fill question
Try the following formula in your first cell.
=OFFSET(Turnover!$D$7,(ROW(A1)-1)*7,0) When copied down it will produce the pattern you need. John Green "John M" wrote in message ... Hi, I want to somehow automatically increment cell references. It would be easier to explain with an example. In my worksheet, i want to list all the all the summary turnovers in my Turnover worksheet. For the first cell, Turnover!D7 is what i want, Turnover!D14 is for the second cell, Turnover!D21 is for the third cell and etc. If i use the normally fill function by holding right corner and dragging i will get Turnover!D8 for second cell, Turnover!D9 for third cell and etc. Could someone enlighten me. It is so frustrating to always add 7 to the previous cell reference. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofill default: I want Fill Without Formatting | Excel Discussion (Misc queries) | |||
Fill data question | Excel Discussion (Misc queries) | |||
data fill question | Excel Worksheet Functions | |||
Data fill question | Excel Discussion (Misc queries) | |||
Fill formula question | Excel Worksheet Functions |