Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update defined name ranges after sort
My application requires adding records (rows) on an ongoing basis, then
sorting on column A (Category). How do you get named ranges to update to their new location after sorting? If I manually move a row, the referencing hyperlink follows. However a data sort does not update the name pointer and I have to go in and edit the range. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update defined name ranges after sort
InsertNameDefine give the name and use OFFSET() formula as below in refers
to =OFFSET(Sheet1!$A$1,,,COUNTA(Sheet1!$A:$A)) If this post helps click Yes --------------- Jacob Skaria "JFU" wrote: My application requires adding records (rows) on an ongoing basis, then sorting on column A (Category). How do you get named ranges to update to their new location after sorting? If I manually move a row, the referencing hyperlink follows. However a data sort does not update the name pointer and I have to go in and edit the range. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update defined name ranges after sort
You can make them dynamic so they are self adjusting using OFFSET or match
or .... =offset($a$1,0,0,counta($a:$a),5) -- Don Guillett Microsoft MVP Excel SalesAid Software "JFU" wrote in message ... My application requires adding records (rows) on an ongoing basis, then sorting on column A (Category). How do you get named ranges to update to their new location after sorting? If I manually move a row, the referencing hyperlink follows. However a data sort does not update the name pointer and I have to go in and edit the range. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update defined name ranges after sort
Thanks for the help
"Don Guillett" wrote: You can make them dynamic so they are self adjusting using OFFSET or match or .... =offset($a$1,0,0,counta($a:$a),5) -- Don Guillett Microsoft MVP Excel SalesAid Software "JFU" wrote in message ... My application requires adding records (rows) on an ongoing basis, then sorting on column A (Category). How do you get named ranges to update to their new location after sorting? If I manually move a row, the referencing hyperlink follows. However a data sort does not update the name pointer and I have to go in and edit the range. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
summing to defined ranges | Excel Worksheet Functions | |||
Create new list with defined ranges | Excel Worksheet Functions | |||
Create new list with defined ranges | Excel Worksheet Functions | |||
dynamic defined ranges | Excel Worksheet Functions | |||
How do I group data using defined ranges? | Excel Worksheet Functions |