named ranges

Excel Friends, I set up C4:C12 to have some values that are added up at C13. I named C4:C12 as SelectedValues, and I named G3 as TotalValue and made it equal to C13. The following worksheet event does not work. Can somebody tell me how to fix it? Just one requirement, the ranges need to be...

Hi, I have worbook with plenty of defined names, each for different sheet. Now i want to increase the range of each of them (they should contain two columns more than they already do). Is there any way that I give list to VBA to go through each of them and adds two more columns?

I've been trying to populate an excel template .dotx and saving it as .doc I managed to get most parts of the code working. But its 4 in the morning and i cant figure out the last part; Dim LastRow As Long LastRow = Groslijst.Range("A" & Rows.Count).End(xlUp).Row...

Hello all, I am trying to write a macro that creates an X/Y scatter chart. The series will be named ranges (ex: Series X Values ='GraphTool.xlsm'!XValues1'; Series Y Values ='Graph Tool.xlsm'!YValuesTemp1". I have several named ranges that I plan to use a for loop to insert them as series as...

I have built a spreadsheet where I export date from a database and paste into Sheet1. I then run a number of formula and graphs etc. The issue is that the column position change, although the column header obviously doesn't. e.g. Price could be in Column A then next time I export in column B...

Below is a set of data I am working on. I have named the customer satisfaction range as "CustomerSatisfaction" then i have applied a filter on the cities ie filter by "Melbourne" then i have named the customer satisfaction column with the filter on and called it...

Hello, Goal = To have a combo box add an item for each cell in a range. I have a userform where a user can select a material, and based upon the material selected another combo box is loaded with color choices that they can select from. But I want this to happen automatically when I add or...

Hello, I am currently using this formula in my named ranges =IFERROR(OFFSET('Misc Calculations'!$T$9,0,0,COUNTA('Misc Calculations'!$T:$T)-1),"") I thought this would help with my graphs so it would only pickup up the numbers in the columns and exclude everything else, primarily I get a #N/A...

I have a workbook with different sheets that are named by year (2017, 2018, etc) and there are named ranges within each sheet (scope is sheet level, not workbook level). I also made a Summary sheet so that i can see a quick snapshot of what was entered for a particular month in each sheet. There...

Excel for Mac 2011 Trying to follow the macro created in this post about copying named ranges: http://excelribbon.tips.net/<wbr>T008811_Copying_Named_Ranges.<wbr>html (Use a macro to copy a bunch of named ranges to a new workbook with the exact same data set, worksheet names.) But in the...

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

This is my first post as is the first time I was unable to find an answer already here great forum. I am working on a scorecard sheet and have named ranges for rows and columns. Rows are named for business functions and columns named for business units. The ranges allow me to simply use a...

Hi, Long time lurker first time poster here. I have been doing some basic work with vba to aid in some of my regular excel tasks. This one is where I rollover a previous months file ready for input with the next month's data. What I am doing is copying the "current month's data" into the...

I have searched everywhere for hours for a solution to this snag I'm running into. I would like to create a named range that will apply to the same area of cells in the active sheet no matter which sheet is active. I have tried searching relative and absolute named ranges, 3-D named ranges, etc...

I have a template that I update weekly with new data. I've written code to create a "report" for broad distribution each week from this template. The report creation works great except for the fact that the links to the template and another workbook that i use as an image databse won't break...

Hi All, I have formula as per below - it works fine. {=LARGE(IF(Departments=B2,Margin),B5)} I have the word "margin" in cell X1, when I replace it in the formula as follows: {=LARGE(IF(Departments=B2,X1),B5)} is does not work... Any help, greatly appreciated. Thanks - Mark.

I've tried to research the combination of variables I think could be causing the problem, but I'm stumped. I have a time tracking spreadsheet (a modified time card) that I'm using to record hours worked on projects, both paid and unpaid. I have a calculation for each period of time worked, then...

I have a master sheet that pulls data from 6 different sheets using an index function. I need to have a the first column on the master sheet display what sheet the data came from. I know I could just add a hidden column to the first column of each individual sheet and have it pull through but I...

Hi all, I have a line of code that is generating the below response. Range("F" & nrow, "F" & llr).Name = Header(iii) Error: <code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans...

Hi guys Struggling here if I'm honest. I've got a CRM userform system where the user inputs data, and should it fall under one of these Business Areas to go into the last row of that named range, which then expands that named range. Business Areas: Marketing Retail Direct (named range name...