| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Dynamic naming of range needed
Hi
I've got a table A1:Y147 where A1:Y1 are the field headings and D1 = "Student ID". What I want to be able to do is to name the range of cells from A1:Y*, where * is the last row where student ID data is found. This should be dynamic, constantly updating upon closing the file, so that the named range increases or decreases according to the increasing and decreasing size of the student id column. Can anyone help? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| WEEKNUM to dynamic range name | Excel Worksheet Functions | |||
| Can't chart dynamic named range?? | Charts and Charting in Excel | |||
| Crate group of date, with Dynamic Range in pivot table not working | Excel Discussion (Misc queries) | |||
| help how to crate group of date with Dynamic Range? | Excel Discussion (Misc queries) | |||
| Add a Dynamic Range with 2 Conditions Q | Excel Worksheet Functions | |||
Threaded Mode
