name manager

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

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

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:= _...

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

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

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

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

Hello guys,</SPAN> I was wondering: is it possible to link an ActiveX Controls (Combo box) and normal Combo boxes to data in other workbooks? </SPAN> I would prefer to keep the data separated from my “Fill in” workbook (workbook that contains the Combo boxes), because the data will have to be...

Hello all, I am currently working on a scheduling workbook for a few of our products, and need to link an image to our product numbers as they appear in the schedule. I have previously referenced this thread http://www.excelforum.com/excel-gene...combo-box.html, and was able to get the...

Hi, I've run into an issue with one of my commonly used workbooks. When I try to share the workbook I get the notification that it cannot be done because it contains Excel Tables or XML maps. Indeed, when I click the drop down Name box, I find a name: "Table2". However, when I click on Table2...

So I had a colleague ask me to come help him with some code that was firing when he closed a workbook that he inheritted. The first thing that struck me as odd was that is was a .xlsx, not a .xlsm. Ipso fatso: no VBA code in the book anywhere. First I had him check...

I used to prepare dashboard in Excel 2007, just got 2013 and added one month's data into it, wherein I did not use any unique feature of Excel 13, this worked well on Laptop. Problem occurred after publishing it worldwide, my colleagues who have Excel 2007, they are getting following error...

I have defined a name for a data range in an excel file. Now I want to use the same name in different excel file. I tried through various sources but not sure how to do that. Current Soln: I am copying the data from the source file and re-defining the names for the range. But this seems to be...

Hello all, I've been doing a lot of work recently with nesting formulas such as vlookup, if, sumif, countif, etc., to reference areas as large as 7-Columns x 5,000-Rows. Although most of the formula references go down to the 5,000th row, the data that I paste into these areas may only go to...

I have made a table with many dynamic formulas that I want to import into the Name Manager. It has the names in Column A and the "Refers to" formulas in Column B. Unfortunately, when highlighting the cells and using the "Create from Selection" feature of Excel 2010 it puts the Column B cell...

I am trying to make a marco that will define a name starting with Spot_001 that refers to Master!$A$2:$M$2 and repeats through Spot_089 or row 99. Ideally it would name as the contents of column A

Forgive me, maybe this is just obvious, I've only recently discovered the Name Manager. I avoided upgrading to the ribboned version of Excel as long as possible but got drug kicking and screaming into it... In the Name Manager, I see a #Ref! error for a named range (A name I never created BTW)...

I am attempting to create a graph that only uses certain values in a table. What I was hoping to do is use Name Manager to select those specific values. For example: Response data is in column Z. There are multiple conditions in several other columns that make the data unique from one...

Hi, In the Name Manager window in excel 2010, I can see numerous names that are in workbooks that I am not even working on. The filter on the top right of the screen is set to "Names scoped to workbook" but it still shows names from other workbooks. is there any setting to show names only in...

We are using a task list which has a fixed number of columns (A-F) but we are constantly adding rows. Since this is something which gets printed often, it's becoming annoying to keep setting the print area each time, not to mention there are some who keep forgetting to set the print area and...