dynamic named range

Hi I have a workbook which contains many worksheets, all referenced via a dynamic named range, collating data as they are added. I learned everything here, so thank you! For example I have datacollection1 through datacollection81 in a column, as per the sheet names. These sheet names are...

hopefully someone can help, i have a sheet of data imported from an external source (the number of rows changes for each import) i have 1 column which displays an employees Hours worked (eg row 4) and then various commisions (eg rows 5 - 9) for each date within the pay cycle using vba i have...

It is my understanding that dynamic named ranges using the OFFSET() Function are not listed in the named range drop-down list on the toolbar. Is there a way to get around this? I need to be able to select the dyanmic named range in order to clear the range and paste an updated list in its...

Hi all. This may exist here already, but my searches have been futile so far. I have a dynamic named range (using offset) in an Excel file. When I try to import the data into Access, the dynamic range doesn't appear in the list of named ranges. If I change the range to a fixed area...

Hi. Quick Question (I hope). How do you create a Clickable Hyperlink in a Cell that links to / goes to / Selects a Dynamic Named Range? I have created the Dynamic Named Range. I have been able to achieve the above with a Static Named Range. (eg Insert Menu / Hyperlink / Place In This...

Hi, i've got a very large spreadsheet for managing stock at our factory. I have two worksheets, one which records stock in and also gives a working stock value, and another worksheet which records used stock everytime a unit of stock is used in the factory. The sheet runs very slow and i'm sure...

Hi, im using a code to create dynamic named ranges. the code is as follows: Sub tryone() ' ' ' Create Dynamic named ranges ' ' Dim wb As Workbook, ws As Worksheet Dim lrow As Long, lcol As Long, i As Long Dim myName As String, Start As String Dim wsName As String ' set the row number...

Im trying (for 2 days now) to create a macro to create a set of dynamic named ranges. there are column headers in row 5 and 5 rows below that there is the beginning of my data. Heres where the sticky part comes in: i have another table below my data that references the above table (that is...

I have come across what I think is an excel bug, or maybe I have done something wrong. I'm using excel 2007<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I have created several dynamically named range that is used to fill active X combo boxes...

QUESTION: Is it possible to use an Excel Dynamic Named Range as a Table / DataSource in MS Query? AIM: I would like to use a Dynamic Named Range to trim superfluous (blank) rows from the Table before MS Query queries it. I was able to achieve close to what I wanted with a Static Named Range...

Hello With this formula I can make a range dynamic for 1 column on the same sheet =OFFSET($A$1,0,0,COUNTA($A:$A),1) What is the formula if I need to expand the range A1:D1 from another worksheet in the same workbook? Thanks in advance for your help Al

Hi. I'd love some assistance with this problem I'm having. Thanks to those who've helped in the past. (And if you're interested, yes it is the same project!) For the short version of this post, skip to "PROBLEM"! I'm assigning a Named Range to be the RowSource of a ComboBox Control on a...

Does anyone know how to remove duplicates from a list created with a dynamic named range? I have a drop down box with a list on sheet1 that is based on a dynamic named range called customer_names on sheet2. Users on sheet1 can either select a name from the drop down list or enter a new name...

Hi there, I have another question that I hope someone can help me with this time. (It appears that my first question was a real stumper! See http://www.mrexcel.com/forum/showthread.php?t=421823) My spreadsheet has a dynamic range dropbox validation in Sheet 1 Col T. What I would like to...

Hello - I have a table that keeps records of requests (no null values). I would like to display the weekly average number of requests. Currently, I have a pivot table running with the table sourced, and I get have the following formula for referencing the average number of requests...

Hi, I have a dynamic named range that i use to populate a chart. I need to now create 50 tabs, with the same chart, but different data on each sheet. I've used lookups to pull the data to populate the charts. However, b/c the range is referencing the 1st tab I created, the charts don't update...

Hi all, Have a reasonably busy workbook with a number of dynamic named ranges which are referred to by many formulas in many sheets. I've already converted them from an OFFSET style to an INDEX style in the belief that this will aid calculation speed (it made a small difference :mad:). Now...

Good Morning All Does anyone have any idea what would cause the formula for a dynamic named range to keep changing on its own? I enter the following formula: OFFSET('Raw Data'!$D$2,0,0,COUNTA('Raw Data'!D:D),1) Which I save and somehow gets changed to the following formula: OFFSET('Raw...