dynamic ranges

I want to create a dynamic range name for a single column. The column will contain dates. The number of rows will change every month when the data is cleared and new data is pasted in. I want to refer to the entire column by a dynamic range name, but I want to end the range before the year...

Hi, I've just figured out how to create dynamic ranges, and learned about PivotTables, but also need to figure out a way to create summary sheets for financial data. Here's an example of the data: Date | Name | Amount | Type | Notes_1 1/9/09 | Citibank | 445.76 | Principal | [Citibank...

I have 8 workbooks. 7 to collect the data and 1 to compile. Every workbook has identical tabs, columns, headings, etc. However, each tab has slightly differnt ranges. (Ex. tab: "BOP" range = B3:O193 | tab: "AUTO" range = B3:K193) It should be noted that, although the ranges accomodate for...

In the example below, the red box is a drop down list so that you can select a specific month & year. I would like a formula that will calculate a rolling average for a total of 12 months including the date in the red box. In this example, if the date selected is Jun-06, I would like to know...

Hi, Please help! I'm trying to create a pie chart using a dynamic named range. The named is piedata and the range is =OFFSET(DataInColumn!$L$7,0,0,COUNT(DataInColumn!$K$7:$K$21),1) When I try to link it to the source data, it tells me the range is invalid and doesn't let me proceed. I tried...

Because my pivot table is used by several users the data source changes often. In response, I created and applied a dynamic range using the offset formula. While the pivot talbe grabs the correct # of records, it inserts a blank column and row. There are NOT any blank cells in the data source...

Sheet1 and Sheet2 has 2 column that consists of Names and Values Sheet2 is where I dump a report too My macro basically compares sheet2 with sheet1 and replaces the old value from Sheet1 The problem im running into is that I can't figure out a way to make my range selection dynamic in my...

Hi, I have calculated data (the column and row headings are calculated as well) similar to this for which I need to create an automatically updating chart. <script language="JavaScript" src="http://www.interq.or.jp/sun/puremis/colo/popup.js"></script><center><table align="center"...

Hello, I'm working on a macro that performs vlookups. The issue I have is that both the lookup value and table array needed for the vlookup will be variable lengths every time. So if I have a 'Summary' tab where my lookup value starts in A2, how do I stop the vlookup when it hits a blank...

Hi - In a gradebook workbook, there is a sheet for each period of a school day. I want to now output a student's data into a single report, either in report sheet, MS Word doc, txt file, etc. A student may be entered on 1 or more of the sheets. If you are good in reporting, here is the...

I am really hoping someone can help me with this:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I have a spreadsheet that:<o:p></o:p> <o:p></o:p> spans over columns A:BM. <o:p></o:p> column headers are in Row 2, data starts in Row 3...