| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a worksheet function to create an unusual cell reference pat
Can I create a worksheet function to say 'equals this cell reference but six
rows over'? I want something like this: in b1: =a1 in b2: =cell referenced in b1 plus 6 rows (i.e. g1) in b3: =cell referenced in b2 plus another 6 rows over (i.e. m1) I'm sick of manually selecting cells! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using COUNT for text occurances in unusual worksheet? | Excel Worksheet Functions | |||
| how do I create a cell reference from ADDRESS function return? | Excel Worksheet Functions | |||
| TEXT function with unusual results | Excel Discussion (Misc queries) | |||
| Macro to Create New Worksheet and Reference Cell in Old Worksheet As Tab Name - "Object Required" Error | Excel Discussion (Misc queries) | |||
| Reference the worksheet from a multiple worksheet range function ( | Excel Worksheet Functions | |||
Threaded Mode
