| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Range Names That Move With Cell Data
Is there a way to assign a range name to a cell, and then have it move with
that cell data if you sort the page? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Range Names That Move With Cell Data
Hi,
Range names do not sort with there ranges. Cheers, Shane Devenshire "DemiUrgoss" wrote: Is there a way to assign a range name to a cell, and then have it move with that cell data if you sort the page? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Range Names That Move With Cell Data
Hi,
If you data is not going to be chaning you can assign a name that will move with the unchanging name, in some situations. For example, suppose your range is E1:E10 with the word Apr within the range, then create a name Apr which is defined as: =INDEX(Sheet2!$E$1:$E$10,MATCH("apr",Sheet2!$E$1:$ E$10,0),0) However, this has very limited utility. If this helps, please click the Yes button Cheers, Shane Devenshire "DemiUrgoss" wrote: Is there a way to assign a range name to a cell, and then have it move with that cell data if you sort the page? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Range Names That Move With Cell Data
Thank you for taking the time to respond to my query.
Unfortunately your answer did not help, but it did give me an idea on how I can adjust my spreadsheet to do what I need. have a great holiday season! "Shane Devenshire" wrote: Hi, If you data is not going to be chaning you can assign a name that will move with the unchanging name, in some situations. For example, suppose your range is E1:E10 with the word Apr within the range, then create a name Apr which is defined as: =INDEX(Sheet2!$E$1:$E$10,MATCH("apr",Sheet2!$E$1:$ E$10,0),0) However, this has very limited utility. If this helps, please click the Yes button Cheers, Shane Devenshire "DemiUrgoss" wrote: Is there a way to assign a range name to a cell, and then have it move with that cell data if you sort the page? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
| need to Copy or Move to active cell from specified range | Excel Discussion (Misc queries) | |||
| Data range to names | Excel Worksheet Functions | |||
| How do you move names and data between large Excel 2003 workbooks? | Excel Worksheet Functions | |||
| HELP REF. NEW DATA ONLY AS i MOVE TO ANY CELL IN THE NEW ROW/RANGE | Charts and Charting in Excel | |||
Linear Mode
