| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill formula down for cells 74 rows apart
Hi
I have a workbook with 2 sheets. In sheet 1 cell A1 I have a formula that reads =sheet2!B1. In sheet1 cell A2 I have a formula that reads =sheet2!B75. I would like to be able to fill the formula down in sheet1 so that it references each cell 75 rows apart from column B in sheet2 Does anybody know how to do this easily, I have to copy the formula from sheet1 down 500 rows Thanks in advance Reg |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a formula tie the fill colours of two cells? | Excel Worksheet Functions | |||
| Macro Formula for counting rows and doing a fill in afterwards | Excel Worksheet Functions | |||
| fill down formula incrementing by every 12 rows | Excel Discussion (Misc queries) | |||
| fill cells with even increment rows from a different worksheet | Excel Discussion (Misc queries) | |||
| formula will not fill correctly due to odd number rows | Excel Worksheet Functions | |||
![Reg[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
