name manager

  1. S

    Show different worksheets with Camera Tool but the ability to edit data shown?

    Using this YouTube video as a guide https://www.youtube.com/watch?v=lCsvSdk4Tro I have created a Dashboard of sorts which has a Dropdown box and this shows data from numerous sources. The sources are mainly Pivot Tables but is there a way to actually edit whatever is being shown in the Camera...
  2. M

    Operation on a concatenated array

    Dear all, I would like to know if there is a way to use functions on concatenated arrays? I have 2 ranges of cells in the Name Manager as follows: Array 1 =Sheet1!$A$1:$A$5,Sheet1!$A$7:$A$10,Sheet1!$A$12:$A$16 Array 2 =Sheet1!$B$1:$B$5,Sheet1!$B$7:$B$10,Sheet1!$B$12:$B$16 When I try to...
  3. A

    Offset and COUNTA in define name

    Hello! Im having issue with putting a formula in the define name "refers to". The formula i used is: =offset(1.Etasje!$C$15,0,0,Engine!$C$4,1). The error i get is : There's a problem with this formula. Not trying to type a formula? When the first character is an equal (=) or minus (-)...
  4. P

    Showing unique entries in the Excel Name Manager

    I have a workbook with hundreds of names. As a result, the Name Manager is hard to navigate--see the image below. Additionally, nearly all my names are defined on a workbook level and refer to ranges, not tables. Consequently, the Name Manager's conventional filter options are useless for...
  5. F

    Data Validation List Alphabetically

    Title says most of it, I want a drop down list to be sorted alphabetically. Currently I have a Translate Table, in which I have named Column 1 'items' and then a dropdown list using data validation is set to =items. If I add an item to the bottom of the translate table it adds it to the...
  6. S

    Name box value is not in Name Manager

    Hello, I have a spreadsheet with 3 tables which are named. These are displayed in the Formulas tab of the ribbon in Excel 2010, in the Name Manager. However, in addition to those three, another range name is displayed in the Name Box. There was unreadable information in this spreadsheet when I...
  7. B

    Dropdown list / Name manager not updating

    Hi all, I've been trying to solve this obscure excel problem over the past few days and can't find any documentation about it online. I've an excel document created in Python using xlsxWriter, but for some reason the cascading dropdown list (in column C) won't display at all unless I manually...
  8. J

    Excel Help in relating to Name manager Data validation Match & Indirect for restricting entering wrong values.

    Hello I defined a name range for certain values & using the named range in Data validation. So that I can enter only those values which are associated with that value. I have Two sheets DATA & RAW DATA In RAW DATA sheet in Column B & C I am entering values manually which are linked with...
  9. M

    Hyperlinks to named ranges using Name Manager for index/menu

    I have searched for add-in's, various terminology, and I'm coming up with very little in regards to my question. I have a workbook with multiple pages (over 40) with 20 "sectors" in each. A total of 800 named ranges. In order to create the index or menu in a matrix style where you click on a...
  10. C

    Create dynamic Long Dropdown List

    Hie, So basically i am creating a form which is more or less like a invoice. There are 4 types of choices from which the user will select, by each selection would give me an another list to choose and so on untill it reaches the last one which is the price, for instance Type- Stock Range...
  11. B

    How to view All the name ranges and deleted unwanted using a macro

    I have workbook with multiple tabs on a worksheet. when I click the name manager nothing happens. How can I view all the names in the workbook and delete the selected names. I try using the macro blow but no luck. Sub DelRefNames() Dim n As Name For Each n In ActiveWorkbook.Names If...
  12. R

    How to find Scope of Names via Name Manager in Excel:Mac 2011??

    Hello Everyone, In Windows version of excel, the scope of names given to the cells or range of cells were clearly mentioned in the name manager. However, in Excel:Mac 2011 the layout and contents of names manager quite different. There is no option to find the scope of names of cell/range os...
  13. badass

    Name manager - how to select all and delete all names?

    Hello fellow excelers! I just moved a worksheet from one workbook to another and all of the defined names have transferred over (thousands upon thousands of them with #REF errors everywhere), making it impossible to navigate to my actual defined names that I want to use...I tried Ctrl + A to...
  14. C

    Name Manger issue with Indirect (two of them), comma giving trouble

    I have 3 columns, the 3rd column reads off of a drop-down list from the 2nd which reads off of a drop-down on the 1st column via INDIRECT. Each of the 3 columns is a drop down list containing text and a few have commas. I have one issue, some of my names in the lists have commas. For...
  15. M

    Name Manager Fun in Excel 2010

    Hey guys, I've had a hunt around and I know there are some really good Name Manager solutions, but my one is a little bit strange. I have a lot of duplicate names in the Name Manager. This was from a rebuild when some LiveOffice components stopped working. When I delete the Name Manager...
  16. F

    Define Name by vba

    Hi, I'm using "Name Manager" in Formulas Tab to define LIST. Exaclty the same I want to do using VBA. I have: =OFFSET('Country'!$E$9,0,0,COUNTA('Country lvl'!$E$9:$E$20),1) Into VB: rows_x = ws.Cells(Rows.Count, "A").End(xlUp).Row wb_1.Names.Add Name:="Country_list", RefersToR1C1:= _...
  17. V

    Require help with "getting answer only if two condition matches"

    Hello, On one sheet1 I have following table -- removed inline image --- And on sheet2 I have following -- removed inline image --- how do put condition so that it matches type 1 and type 2 and give me result for Grade. For Example If I have type1 FT and type2 BIG and Rev is 3145, it...
  18. J

    Switching Between Viewing Names and Formulas

    Hi All. I am a big advocate of the use of the name manager to name cells, ranges etc as it can often help understand what you are trying to achieve however a number of spreadsheets I use have upwards of 300+ names in then and it get annoying to having to go to the Name Manager to check if the...
  19. J

    How to utilize name manager

    I recently downloaded a template from office.microsoft for a GANTT chart. This chart seems to utilize dynamic cell selection to change the values that are withheld in the name manager. These new values are used as conditional formatting to change the color and placement of color within a cell...
  20. A

    Name Manager Won't Open

    I have seen the before, but could never fix. Suddenly in a file, I cannot invoke the Name Manager window either by button or keystroke (I still use the old Alt I+N+D). I type pretty quickly so maybe I hit some "toggle" that I don't know about? Everything else in name manager works (I can...

Some videos you may like

This Week's Hot Topics

Top