named ranges

Hello, I am extremely limited in my knowledge of VBA macros and cannot seem to find the exact solution on searching through forum posts. I am trying to write a macro that hides the row when you mark the cell in the last column of the named table range. For example, Table Name = "Ben" for...

Hi, I am working on a dashboard where I am creating drop down dependent charts. For this I have used camera tool to display the picture of graphs (created in separate sheets) selected in the drop down and I am using CHOOSE function to decide the order. The problem is all my graphs are not...

Hello, I have the following two macros which separately work but when I run one and then the next, they don't to build on top of each other and work in unison. running macro 2 undoes macro 1 and vice versa. Essentially what I need is: a) hide entire rows where individual row total = 0 (Macro...

Hi all, I have an Excel 2010 workbook in which I am using a Workbook_BeforeClose event to do a number of things. The part I am having trouble with basically is designed to remove all existing named ranges, then recreate them based on the rules in the code. The reason for this is because users...

I have two worksheets in a workbook (WellbeingDashboard); Charts and Data. The data I am looking at includes product data (five products), accounts and user metrics (two metrics), by state (two states). I am trying to create a single chart (stacked area) that trends the change in a user-selected...

Hi all, I currently have an Excel 2010 workbook containing a number of macros to hide columns. Each column is for a specific location (arranged alphabetically) and has it's own hide button which basically hides / unhides all OTHER columns than the one with the button. For example: Sub...

Hi, I have a control sheet with a number named ranges. A formula with one of these (which was previously working) is now coming up with a #NAME error. I know this means that it's not recognising the named range as legitimate, but I've tried all the usual things to resolve, and I still can't...

Hi all, Another day another query it seems! I have an Excel 2010 workbook and am looking to mass rename a whole load of named ranges. Having spent the last 30 or so minutes doing so manually, I then scrolled through the list and realised I wasn't even a quarter of the way through yet...

Hi - I want to name a range that will select the same rows no matter what worksheet I am on. For example - if I call it "selection" - whenever I pick selection it will choose rows 20 to 25 no matter what worksheet I am on in the file. Any ideas?

Hi all, I have an Excel 2010 workbook that has a number of columns as dynamic named ranges designed in such a way that the ranges expand as new data rows are added. This has been achieved using the following example RefersTo: codes Name: Screening_Location RefersTo...

Hi all, In my Excel 2010 workbook I have created some dependant drop-down lists. On a hidden sheet called 'Background Data' I have the various dependencies set out in tables which have been given named ranges. Initially everything was working fine on my test data, but when I started adding in...

In Excel 2010 I have recently started swapping out referenced ranges for named ranges to account for additional data being added without formulas breaking, and on the whole this has been a success. I do however have a single formula that refuses to play ball using the named range, despite...

Hi I've got a workbook which has a "Dashboard" worksheet which displays drop down boxes to allow viewers to customize what PROJECT AREA is displayed on their dashboard. The workbook contains multiple tables on multiple worksheets for storing information such as cost, revenue, performance etc...

I've got a very large template workbook with quite a few worksheets which is used for preparing labor and expense estimates for projects and then for tracking actual labor costs and expenses against the estimate. I now have a new version of the spreadsheet and we want to migrate all the older...

I set up a workbook with all kinds of lovely formulas (they really are) and a chart to pull all the data together. To make it as flexible as possible for the end user, I used named ranges so that salespeople can be added or removed and the chart would automatically update. I've used named...

Hello - I'm attempting to convert column data to row data. I currently have 16 columns and I would like to shrink this down to 6 columns. I have about 20 hours experience working with VBA and I'm stuck. Any guidance would be most appreciated. The current headers and layout is as follows...

Hi all, I have difficulty in building OFFSET formula to access my chart data dynamically. My data layout is as below. <tbody> State FL AZ TX ID Qty xxx xxx xxx xxx Sales xxx xxx xxx xxx Cost xxx xxx xxx xxx Profit xx xxx xxx xxx </tbody> If I select any...

Excel 2010. I have a Table structured in this manner: <code style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif...

I have created a named range that goes across multiple tabs. The range name is associated with a string that looks like this: ='Customer Retail:Customer Retail (END)'!$A$5:$X$5000. I need to either create a table on a separate sheet that includes all of the data from this range so I can then...

I am trying to sum a column using multiple variables in named ranges. So far i have only been able to get the formula to work using one or a few of the criteria. I started with this but it's not working. "=SUM(SUMIFS(Amount,Dept,{"Boston","Atlanta"},PartNo,{"PYFO","PYRH"}))". Below is a...