name manager

Good day, I named a cell to "XYZ" and use it in Power Query as Excel.CurrentWorkbook(){[Name="XYZ"]}[Content]{0}[Column1] The question is, - if possible - how can I use a Defined Name in Power Query if it isn't refered to a range/cell but have an exact value? Thanks in advance!

In VBA, I have a multi column range on one sheet (DocMgr!$Q$8:$V$27) where, on another sheet, I need to find the max value in the second column if the first columns meets a certain condition. The way I found to do this is to write an array formula to a cell and then get the resulting value like...

Hi, I copied a tab with a million named ranges and formulas. I’d like to rename all on the new name to be prefixed with a tab indicator while leaving the original named ranges unchanged. Currently the name manager has duplicate entries for each name, distinguished only by address. I found...

I have a workbook with a summary worksheet that leverages a large data set that I pull down from accounting monthly. The monthly data pulls are preserved on individually named worksheets (e.g. Feb22AllTrans). I have 5 named ranges on the monthly worksheets that my summary worksheet points to...

Hi, I have a list of names and range references to load into name manager. Do you know if there is a way to import them in bulk. For reference I've tried create from selection but it can only store values not the range reference. Example of name to import Name_1...

Hi all. I am new here, so apologies if I miss any conventions with making this post. I'm using Office 365, on Windows. Here is a link to a screen-recording of the spreadsheet/dashboard. (Unfortunately the screen-recording does not capture the drop-down list, for some reason, but you can clearly...

I made an excel sheet with a dynamic print area formula in Name Manager in workbook A and it worked. Then I merged the sheet with another workbook B, copied the formula and now the formula is only running once. It is updating the print area to current area but afterwards when I chance the...

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...

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...

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 (-)...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...