dynamic ranges

Hi, I have a pivot table that uses the OFFSET function to drag in my data dynamically as kindly shown by Bill "Mr Excel" Jelen. The issue that i am having now is that im having now is that when i go to filter my data i get a alue of "0" that can be filtered on. If i look in my data, there is...

Hello, I'm new to loops. I need to write a macro that creates a PT for each column in a datasheet. The number of columns and rows is variable. The PT is simple it will only use Column A and then 1 other column at a time. I would show you my code but i'm having trouble with where to even start...

Hello, I've created 2 dynamic ranges: Last30Days which captures the range of the past 30 days formatted as Short Dates. Last30DayCOGS which captures the range of cost of goods sold on those past 30 days. I'm trying to get the average sale by day of the week for the past 30 days. Monday...

can someone please help me with the offset function for one of the worksheet in the below workbook. When a new row or column is entered the range should expand. I tried something like: =OFFSET(Sheet1!$A$1, 0, 0, COUNTA($A:$A), 1) but it does not work! Once I get one sheet working I think I...

I am new and have searched endlessly for a couple of days to try and figure this out. Thanks in advance for any help and insight... sheets(1) has two columns; Column A is href links and Column B is FileNo Macro looks up href links on sheets(1) and utilizes a webquery to pull table...

Hey, I have Date field in A column and Temperature in B column. A column goes on till today's date. I have to calculate last seven days' average temperature whenever I open the Excel workbook. If I enter Today's date in C7 (in C7 TODAY function is there), I want the last seven day's average...

Thanks for looking ! I have bits and pieces of code below to attempt this.The code is incomplete. My Goal is: When Data is entered into textbox1 and textbox2 that information will go to the last empty row in columns H and I (which is Dynamic Range "Operators") when clicking on command button 1...

I had the great idea of changing some of my named ranges to Dynamic Ranges. I did not research this before doing so, now nothing shows up in my drop downs. All I have in the Data Valadation Source Box is =INDIRECT (I28) I have read that Dynamic and Indirect dont go together. If someone could...

Hi Everyone, I am using the camera tool to automatically update pivots for country specific data which are kept in their own sheets (USA, Canada, Mexico, Brazil are all in separate sheets). When the monthly data feed is updated, the pivot tables expand and grow in size (rows). The camera tool...

I am looking for a way to dynamically number non-blank rows in a quote template (ie Item #). The Template looks as follows: B1 C1 D1 Item # Qty Description ... 1 2 Product A 2 1 Product B 3 4 Product C...

I have looked around and there are plenty of threads about this topic, but nothing really for what I'm looking for. Essentially, I have a list of tasks. Each week, I am pasting a new set of tasks into the same sheet. However, many of the values are the same (task headers). These headers are not...

I have 2 ranges (each with headers and underlying text data) stacked on top of one another on the same worksheet. I am attempting to write a macro that autofilters the first range, copies and pastes data I need from each column to a separate worksheet, and then moves down to the second range...

Hi everyone, Problem: Would like to be able to build a formula where one of the cell reference contains the Name of the range I would like to use in the formula. Context: I have a real workbook which has 32 series of values which were collected with a process control system logger at 1...

Hi all, I am hoping to get some help from experts:rolleyes:. I have a table which summarises the total cost of the items (see Table 1). However, I need a macro which insert two rows under each Main category in Column A (where my main catergory is 1, 2 or so on and sub category is 1.1, 1.2...

Hi there,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> Does anyone know how to put dynamic range references into an array formula?<o:p></o:p> <o:p> </o:p> I’m looking to do this to speed my sheet up, by allowing the sheet to only calculate...

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...

Hi all, brand new to the boards; relatively new to excel and can't seem to get the following to work. In cell A1, I want to choose an industry from a list that is dynamic. In cell B1, I want to choose a client from a list that corresponds to the industry selected in A1 - this list is dynamic...

Hi, I am trying to change the ListIndex of a ComboBox(2) based on a value driven from a previous ComboBox(1). - ComboBox(1) is a customer drop-down list on Sheets("Sheet1") - Based on ComboBox(1) selection Sheets("Sheet1").Range("F1") is updated with a lookup value -...

Hi all, First posting on here and I would really appreciate your help. I have a list of data with repeated values stored in a dynamic range. The range needs to be dynamic because the range may increase later and there may be new values introduced. I want to use a data validation drop down...

I have successfully updated charts using the knowledge on "spreadsheetpage.com" which works for data that expands downwards using dynamic range names using eg A B date sales 1/4 565 2/4 603 3/4 581 etc using range names of sales. ie =offset(sheet1!$B$2,0,0,counta(sheet1!$B:$B)-1)...