named

Dear All, I need help for building a Macro for my store balance for all products. My original excel file is here: https://drive.google.com/file/d/1dpASKSVYVb2BUu7HqSryIEsv-Yc31pSf/view?usp=sharing There are some sheets in the workbook. In the sheet named "Previous Database", I have arranged...

Hi Whilst I have a get around solution to this problem I wondered how others may implement the problem. I want to refer to one of two named ranges in a formula using the RANK function in a cell. A value in another cell in the same row is used to determine which named range is used. How can...

Hi, I have a table of legal entities (L.E) and divisions in those entities, which I do not want to transform. I am aiming to produce a drop-down of relevant divisions for selection using data validation in another cell. Here is my dynamic range...

I have encountered a very usual error that I have tried to resolve for several hours with no luck. The code involved is spread over several procedures, so I don't think it would help to include it here. As an overview, my code does the following: Prompts the user to open another workbook...

Hello everyone, I have userform named "operation" with several textboxes and command button named "cmdUpdate" this button to copy the boxes values after editing it to sheet named "DT" in an existing row it doesnt add new row the code for this button as follow Private Sub cmdUpdate_Click()...

Each worksheet has a named range. How to write VBA code to import/append into 1 access table using the named ranges. I know how to use the TransferSpreadsheet method for 1 worksheet and use the range name, but not sure how tp write the loop to get the multiple range names from all worksheets...

Hello I am trying to write a change event which when the value in H6 is >0 the named range "GreenTemplate"(which is three rows deep) is copied and inserted below named range "insertRow" and then the inserted rows are named "GreenQ1". Then if the value in H6 is cleared the named range is deleted...

Hi all, I hope that this is an easy one for you folks. I'm trying to return a result with an index formula. EG. =index(Dynamic_Named_Range,1) Works fine. However the Dynamic_Named_Range is referenced through a Static_Named_Cell. I thought a formula like =index(indirect(Static_Named_Cell,1)...

I have two combo boxes. List of Combobox2 is dependant on list of combobox1. Combobox1 has list of companies. Combobox2 has codes of products the company(selected in combobox1) provides In label1 I want to have name of the product for which the code is selected in combobox2. For the record...

I am using the following formula to check if a contact's job title, stored in cell K5, is found in a named range of job titles. SUMPRODUCT(--ISNUMBER(SEARCH(LeadershipTitles,K5)))>0 The problem is that this formula returns TRUE when the value in K5 is "Sales Coordinator" but that text (i.e...

I'm running into a bit of a problem trying to do a lookup whereby I search for a specific table (with its own named range) and then a column within that table which corresponds to a row. Here's an analogy to make it a lot easier to understand: I'm a teacher with a grade workbook. I have...

I have ~100 named ranges in a spreadsheet to reference daily production for oil wells. One data set is named AH717H for example. Typically I use a vlookup or Index Match like this: VLOOKUP(A2,AH717H,3,false) where A2 is a date. Pulling down this data for all ~100 wells which each have several...

can someone answer this. This formula works =ROUND(IFERROR(LOOKUP(1E+100,SEARCH(" "&prod&","," "&list01&","),'2012 price changes'!$J$3:$J$2521),""),4) I have a cell, F11 that I have "J" in. I want the formula to go to F11 and replace J with what is in F11 I can't get the below to work...

Hi guys I have data in 2 named column range (real data was 81 column & growing 60.000++ row data) name "key" in range column A:A (string) name "value" in range column B:B (decimal) data example: key, value A, 10,212 A, 12,990 B, 11,119 B, 9,888 C, 2,911 i want to round every value first...

Is it possible to have a formula IF current sheet is named X?

Hi all, The below code works, up untill the last "<>Alternatives" =SUMPRODUCT(SUMIFS(Aladdin_notional_weight,Aladdin_country,A4,Aladdin_portfolio_full_name,"<>Alternatives")) Are named ranges not compatible with the "does not equal" function? Any work arounds?

Hello, I have one Worksheet (Sheet1)where a user enters three items: "FirstName", "LastName", "City" in B1 to B3 I would like to click a button to then take the three values and pastes into other worksheets in workbook. ie Sheet2 has a named range called "FirstName". VBA to look for...

There is 3 fields to fill in on Worksheet: Cells A1 to A3 . And customers put data in Cells B1 to B3. FirstName: LastName: StateName: I would like VBA to take the open worksheet and copy the data into Worksheet2 transposed from columns to rows. I would also like to have named ranges...

Hi I want to use VBA to create named range columns for all the US Presidents starting in Col E, Row 5. The names will all be listed across row 4. The row length of the data below is variable ie 100 to 200 rows so maybe use last row? Thanks in advance, Mike

Hi, We have two workbooks, one logs delivery statistics, the other logs sales statistics. At present we have the sales workbook looking at the delivery workbook to pull out milages etc. The workbooks have a tab per month. The data is pulled across using Index & Match with named ranges. My...