named

Hi Folks, I'm trying to figure out if there is a more efficient way of doing the following. I have a bunch of named ranges for two different variables that I use a drop down to select (well a dropdown that selects a name that then references the named range and puts its data in the correct...

Hi there, I am trying to figure out how to return an item from a named range using a radio button on a different worksheet. Ideally, I'd like to be able to return a single item and then in another separate instance return a whole array. So below, the single item example would be click one...

Hi Gurus, I have a defined name referencing a column in a worksheet that is actively calculated. It is called _5yrDates and is simply Today() - 5 years. Other sheets use this name to grab the same data. When I close and reopen my file and click on the first cell in the named range, it has an @...

Hi, Firstly I don't believe this is possible but thought I'd check. Is there a way to name a formula, so like how a named range works but for formulas so say "INDEX 1" could refer to a long index formula to shorten the characters in the formula box. Thanks, Paul

Hi Folks, I have a question, is there a way (a formula) that i can put in a first cell of a named column and have the formula sum the entire column EXCEPT the first cell of that same named range? This formula "=sum(index("My Named Range",,11))" results in a circular error because its trying to...

I want to enter a formula in sheet name "calculation" B4 that if the Date in Sheet named "Raw Data" Header named "Date" is withing the week 44 date that in the Sheet named "Calculation" D2 sum the data in the sheet named "Raw Data" heater named "Count of Assets in BU"

I need a formula that i can put in a sheet named Calculation B:54 that if in sheet named Raw Data anywhere column D there the words "AIM 2019" it will add the total numbers in Column G of sheet named Raw Data.

Hello, Normally we create named ranges by referring to excel lists - we select the data range that is located in certain cells in worksheets. I tried to create named ranges by manually adding data to "refer to" part. But it didn't work - all the data that I added appeared in one cell, so not...

Hi all, I am having trouble with the consolidation of my named ranges into the one pivot table to finish a dashboard. I have got all the named ranges into the data source. Each named range is the same shape: that is, each consists of 4 columns. Columns are Amount, Animal, Location, and Colour. I...

Hi there, I have stucked in the above said. I have named the lists. Like 12 different training given in April month, I named the training list by "April". Now I want to show it like if I select "April" in a drop down list, the names of all training should come in next or desired cells by list...

I want to be able to copy data from a different sheet to a specific feel in a another sheet. I have a sheet named GSO Inventory Stats and a sheet named Retag metrics. I need to put a formula in Column I, that if Column H in sheet GSO Inventory Stats matches the sheet named Retag Metrics Column...

So I have an interesting one for you all. I have a master workbook I made for a gradesheet and put it in the public folder. When a new class starts the instructor will make a new folder for that class and copy the master book into that folder. It is still in beta mode, so as the classes have...

I have a Sheet Named NEA Status and a sheet Named Inventory Stats I want that if Column D in Sheet named NEA Status Matches Column D in the sheet named Inventory Stats move the data from Column H in the sheet Named Inventory Stats to Column H in the sheet named NEA Status.

Hi All I want to return the cross reference of 2 named ranges. There is a sheet called Front Page where i want to return the result and the information is on a sheet called Commission Row named range = Partner Column named range = Finance Both of the named ranges will be referenced in as...

Hi All, I have a worksheet with 52 weeks of personnel planning. These are grouped columns with an empty column in between each week. The groups are in columns E:PL. Each of the weeks are named ranges. Columns A:D have text (ie. work path, area, etc.). For the user, the columns are frozen to...

Hello, I have a multi-sheet workbook and I am having problems with a cell in sheet 1 that references another cell in sheet 2. That second cell is populated by means of a drop-down list and I’m sure that’s where my problem lies but I don’t know how to fix it. I keep getting the #N/A error...

I started using the INDIRECT function to create a super dynamic Sumif that references a named range based on criteria. However, I noticed that my calculation time has increased significantly since taking this approach. I read online that this is a very volatile function that performs slowly...

Is there a way to delete all named ranges from a selection? Here is the selection that I am trying to delete the named ranged from: Range("CompOverviewTable[[#Headers],[Competitor_one]]").Select Range(Selection, Selection.End(xlToRight)).Offset(-1, 0).Select

I have a named range in a large spreadsheet that I suspect is being used for either a) data validation for some cell or b) as a rowsource for some combobox on a userform. Is there a "simple" way to find out where exactly it's being used? My understanding is that trace dependents will only check...

Hello, I have a script with an IF Range("A" & r) value is also in a lookup list AND Range("I" & r) THEN do something. I know I can do a bunch of ORs but that doesn't seem particularly neat. IF Range("A" & r) is in Lookup list named Type AND Range("I" & r) IS NULL Then DoSomething. Any ideas...