| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
references
I have a list of dates (consecutive weekdays - some holidays) in Column D in
Sheet2. In sheet1, I have a reference to those days. For example in A3 I have the formula =Sheet2!D3 which displays the correct date. I'd like to copy the formula to every 7th cell in Column A in Sheet1. What's happening now is that the copied formula increments by 7 The formula copied into the cell A10 is "=Sheet2!D10". How can I force it to increment only by 1, so that it references the dates in Sheet2 correctly? Thanks Bert |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel references within references? | Excel Discussion (Misc queries) | |||
| Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
| References | Excel Discussion (Misc queries) | |||
| references | Excel Discussion (Misc queries) | |||
| How to rename references from range names to cell references | Excel Discussion (Misc queries) | |||
![Bert[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
