| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Linking names
I am wanting first to name a group of cells like A1:F8 and then link that
name to another sheet. I tried to name the group using the equation: =OFFSET(sheet1!$A$1:$F$8,0,0,COUNTA(sheet1!$A:$A), 6) Is this the right eqation or am I missing something. Then how do I link that name to another sheet. thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding Duplicate Names from Different Lists... | Excel Discussion (Misc queries) | |||
| sorting names alphabetically when names may start with numbers | Excel Discussion (Misc queries) | |||
| Linking with names | Excel Discussion (Misc queries) | |||
| Linking Names with Codes | Excel Discussion (Misc queries) | |||
| How can I find the common names in two columns of names? | Excel Discussion (Misc queries) | |||
Threaded Mode
