Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Named Ranges in Excel (update and create)
I have the following situation
PC DESKTOP MONITOR PRINTER ibm hp dell hp toshiba I want to have excel create named ranges for each category (PC, DESKOP, MONITOR and PRINTER) I also want to automatically update the created named ranges once a new item is added to the list. I also want new named ranges to be created once a new category is added (for example SCANNER). Is that possible and how to do it? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Named Ranges in Excel (update and create)
Hi,
Take a look at Debra Web has an excellent explanation and samples http://www.contextures.com/xlNames01.html http://www.contextures.com/xlNames03.html If this helps please click yes, thanks "Ixtreme" wrote: I have the following situation PC DESKTOP MONITOR PRINTER ibm hp dell hp toshiba I want to have excel create named ranges for each category (PC, DESKOP, MONITOR and PRINTER) I also want to automatically update the created named ranges once a new item is added to the list. I also want new named ranges to be created once a new category is added (for example SCANNER). Is that possible and how to do it? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Named Ranges in Excel (update and create)
On 16 jun, 14:23, Eduardo wrote:
Hi, Take a look at Debra Web has an excellent explanation and samples http://www.contextures.com/xlNames01...xlNames03.html If this helps please click yes, thanks yes, thanks ;-) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rapidly Create a Large Number of Named Ranges | Excel Worksheet Functions | |||
Excel 2007 Named Ranges | Excel Discussion (Misc queries) | |||
Create list of Named Ranges | Excel Worksheet Functions | |||
Accessing named ranges in Excel from VBA | Excel Discussion (Misc queries) | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) |