dynamic range

Hi, I'm trying to have a range of cells vary according to other factors. INDIRECT(ADDRESS(1;MATCH("Y";AT2:BZ2;0) What is highlighted in red is what I want to change according to other formulas. The thing is you can't put it in text so I don't know how to have it written in the formula to be...

Hi, I am trying to automate a very long process with excel. I work in a motorsport business and I would like to do application charts automatically in excel. Let's say, a bearing fits on a XXXX 4-wheeler from 1996 to 1998, 2000 and 2002 to 2005. I want to have this written this way : 92-98, 00...

Hi Mr Excel, I really need some help, i have been trying to find a workable solution for a problem i have calculating averages. I'm looking for a formula to show the calculated average in cell B2 of the included sample, were the range (currently B3:B4) updates automatically when a new row is...

So I've looked literally everywhere - by which I mean on the first page of Google and no further. I have sheet 1 that does scores and points and more scores for each team (column C5:C54). These scores lead to a total score in column N5:N54. Thus Column O5:O54 shows the ranking by the RANK...

hi, first i want to apologize for my bad english. i Need help for coding a VBA macros with multiple dynamic ranges and offsets. Here is the file link for exemple. https://drive.google.com/open?id=0B73QGIX8lusWLWlRS1dNamFjdEE thx for help and time.

I've created a report in excel. The intent is to paste the data into the data tab and refresh the workbook to populate all tabs. I have additional columns that contain formulas that populate based on the data entered. Each extract will have a different number of rows, so I would like these...

Hello All - first time using VBA in a while. I have some pretty basic code I need to tweak to select the visible cells in a range. If it's not asking for too much, I'd also like to make this range dynamic (the number of rows is the only thing that varies, number of columns will be constant)...

Hey everyone, So I am by no means a VBA coder. What I have done hear is recorded macros and then manipulated the VBA code behind them. I have a particular piece of code that is acting as a bottleneck. What I'm trying to do is generate percentages from the cumulative total of a dynamic range...

Hello All, I want to use a named range in the LINEST formula (European version of Excel). It works fine if I just use a dynamic range in the formula like this: =INDEX(LINEST((INDIRECT(ADDRESS($AQ$1;22;4)):INDIRECT(ADDRESS(COUNTA(B:B);22;4)))...

Hi, Appreciate any help I can get regarding my post. I'd like my report to be able to automatically populate cells based on the information from a column. I currently have a very long nested if function under column G, which checks the information in column F. But what I'd like to do is...

Hi All, I am working on a program and run into a bit of a problem I am looking to get help with. I have a dynamic range that varies depending on user input. I am trying to add code that selects the range and ensures there are no blank cells. If a cell is found to be blank in the range I want...

I’ve been banging my head against the wall trying to figure this out :banghead: I don’t have any training in Excel or VBA. Everything I’ve ever learned to do in Excel has been from looking stuff up online or picking apart other people’s spreadsheets to see how they did something. My problem… I...

Hi Guys, I have a dataset heaed by date and a bunch on data under I want to be able to count the occurances of a particular cell based upon the data under a selected date. I want to be able to change the date and the subsequent range change based upon this - so the count is only counting...

Hi, I'm trying to create a formula that will allow me use some exported data to create a simple summary of it, which will be used for other calculations. Our system exports data that looks like this: <tbody> Date Item1 I want Item1 SUM here Lot1 1000 I want to drag the same...

Hi All I am struggling to find code for this, I have looked through the forums but haven't found one that works for me. All I want to do is have a print function on a report tab that varies in length depending on the results given. Columns will always be from $E2:$U - depending on the results...

Hi! I know there have been a lot of threads for finding the unique values using macro but my problem is unique in its own way. I need to compare 2 columns from two sheets of the same workbook and find the unique value. The data that I need is from Sheet 2 column C. Sheet1 Column B has a lot...

Hi All, It’s my first post in this forum so hopefully I’m following all the rules correctly ;). Anyways, I hope someone can help me with this this “dynamic charts” question. Here is the situation: I am trying to create a bunch of combo charts, and part of the combo is a line chart. For the...

Hello, The Background: I'm currently working with a pivot that is drawing information from a query. The query's number of rows change, so the pivot's does, as well. The number of columns won't change anytime soon. The pivot is located in the CBPivot tab. I'm using Index/Match to pull the...

Hello, I have an attendance sheet where students' names are in column A, attendance percentage (calculated using data from columns C and beyond) in column B, and the dates of classes are in columns C and beyond. A new column is filled with each class held where 'true' indicates that the student...

I need to match 2 criteria acct# is one the date is the other. However id like for the date to be able to sum all the data in the cells that are a date prior to the reference date. Ex. I have sheet 1 with Jan-Dec in K4-V4 and data below. I have a reference date in sheet 2 3/31/16. I'd like to...