| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column reference
How can I find the column of a reference I have in a different worksheet?
For example in A1 I have ='D:\Work\[Vars.xls]Sheet1'!D$4 which makes reference to column 4 in D:\Work\[Vars.xls]Sheet1. I would like to find that column number without entering the address, since that might change. Or associating it to A1 so that if I change A1 the column number would change automatically. Thank you, Manuel |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to reference one column against another | Excel Worksheet Functions | |||
| Column reference and column count | Excel Discussion (Misc queries) | |||
| Row reference increment but preserve column reference | Excel Worksheet Functions | |||
| Macro to Reference Column Next to Current Reference | Excel Discussion (Misc queries) | |||
| I need to find the Average from Column A - but Reference Column B | Excel Worksheet Functions | |||
Threaded Mode
