defined name

Hello All, I was sent a file that I am trying to analyze to be able to modify going forward. This was made at another site by an employee that no longer works there so I have no real reference on how it is supposed to work. The main issue is with the Hyperlink function and potentially using...

Hi, I have a listFiles named range to return a list of files of a specific folder into Excel. I use the following formula: =IFERROR(INDEX(listFiles,ROW()-ROW(A$2)),"") I was wondering if there is a non-VBA solution to automatically/live update the files list in the Excel named range whenever a...

Hello, I'm slightly above a novice with Excel. I'm trying to figure out a quicker way of returning values from a master data sheet to another sheet that is showing the individual categories. Master data has approximately 14 teams. Each team is scored on 8 different metric ratings every month of...

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

I have a spreadsheet with nearly 5000 defined names. We have a code that transfers filled out information from the template, to the most recent release of that template to capture any changes in sale prices or new items. So they are both the same spreadsheet except the most recent template has...

I want to loop through all of the defined names pertaining to my sheet. That's the easy part, the issue i am encountering is that the workbook's many auto filter ranges must be stored as a defined name, which is not want i want. None of those filters were named intentionally. And the code i'm...

Hello, I created a scenario summary and in the Result Cells column, all I get is a cell reference. Is there any way I can do a look up of that cell number located in the other tab so that the "Defined Name" of that cell displays where I wrote the "?"? I've been searching the web for days, no...

While playing around with defined names I found some behavior that seems to be inconsistent between using defined names within a formula in the workbook environment and defined names within the VBA environment. I have two questions: Can others duplicate this behavior? If others can duplicate...

Hi All Im getting a bit lost on what im trying to do here I have the named range value in Cell D5 and this range changes dependant on other dropdowns, which then creates a data validation list in a tabular from im building, but i want to build a summary table where the list of values in that...

I have an Excel problem I cannot seem to solve. I am trying to do a dynamic shape/color change based on a percentage, the index of shapes and matching percentages are in B10:K10 and B11:K11. Defined Names - Status =INDEX(Sheet1!$B$11:$K$11,MATCH(Sheet1!$M$11,Sheet1!$B$10:$K$10,0))...

Can two list that have a Defined Name be merged to be used in the Data Validation as a dropdown list?

I would like to access some defined names in my VBA code. These names have a ReferTo value that is a formula. For some the formula evaluates to a single value, like 5005 or "The Client", and for others the formula evaluates to a range. After quite a bit of searching I haven't been able to find...

I am attempting to define names for all cells in an entire column of a range. In this column, there are repeating values, which are always next to one another, by design. What I am looking to do is to have each set of cells that have the same content (again these cells are next to eachother)...

Hello, I've created a PivotTable with VBA which works fine. The problem is that when I delete and create a new pivottable on a new worksheet to update the values, all of my formulas on an existing worksheet end up with the #REF error. I need to reference this PivotTable to do a VLookup of...

I'm trying to do something that I thought was going to be simple; however, it's turning out to be a pain. I have 2 worksheets, sheet1 and sheet2. In sheet 1 I have a list of all of the worksheets in my book populated via a formula. In an adjacent column I want to return the address ($A$5) of...

I am having a problem with a simple loop that I want to run x number of times based upon a defined name in a worksheet. My defined name is Clients=counta($A:$A)-9 I have a macro that I am trying to execute that will copy a range down a number of times based upon the value found in the defined...

Hi, I have a sheet with 20 column and wanted to use the column headers as names, so I opted the Create name from selection option. It was a breeze to create so many names so quickly, but the problem is the scope of the names was set to Workbook. Is there any way to change the scope from...

Hi guys, Having some trouble deleting defined names from my workbook which were actually created in an entirely different project! 1) How the hell did they even get in there (pretty sure the workbooks weren't open at the same time)? 2) Why can I not delete them - the delete button is greyed...

Hello, everyone. I am trying to delete a named range and then delete the defined name also, so that my name manager is not full of old names. I recorded my actions while trying to delete a range called "Area2." The code that was recorded was: Sub Delete_Named_Range()...

Starting with a spreadsheet full of data. In Column "A" contains the "production line" , column "B" contains the "production date", Column "C" contains the "Product" and column "D" contains the response data. Is it possible to use "defined names" to create multiple groups which could be...