| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reference a cell from a another sheet that is always 24 rows away
I need to reference a cell from a another sheet that is always 24 rows
away and in same column. i.e. B52='HOURLY ANALYSIS'!BI1507 B53='HOURLY ANALYSIS'!BI1531 How to I get 'HOURLY ANALYSIS'!BI1531 to change automatically without changing it manually? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy rows to new sheet based cell reference, not value | Excel Discussion (Misc queries) | |||
| Setting a cell reference in one sheet that updates a workbook? | Excel Discussion (Misc queries) | |||
| Copying a work sheet cell reference as relative not absolute? | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
