| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy/Fill Down in increments
I have a fomula on sheet1 that refers to sheet2 and I want to copy/fill down
adding 51 each time. Example in Sheet1 cell B4 is =Sheet2!E5, I want the result in B5 to be 51 rows later ie =Sheet2!E56 How can I autfill or copy down to automatically add 51. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy/Fill Down in increments
In Sheet1 cell B4 try the below formula and copy down
=INDIRECT("Sheet2!E"&(ROW(A1)-1)*51+5) If this post helps click Yes --------------- Jacob Skaria "Helen B" wrote: I have a fomula on sheet1 that refers to sheet2 and I want to copy/fill down adding 51 each time. Example in Sheet1 cell B4 is =Sheet2!E5, I want the result in B5 to be 51 rows later ie =Sheet2!E56 How can I autfill or copy down to automatically add 51. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy/Fill increments | Excel Worksheet Functions | |||
| How to create a fill down that increments based on the workbook name | Excel Worksheet Functions | |||
| How to create a fill down that increments based on the workbook name | Excel Worksheet Functions | |||
| Edit Fill Series - How do I fill using minute increments | Excel Discussion (Misc queries) | |||
| How to create a fill down that increments based on the worksheet n | Excel Worksheet Functions | |||
![Helen B[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
