dynamic

  1. T

    Excel Formula Multiple Criteria with Moving Header Changing to Different Column

    Hi, just wondering if this is a possibility with the Index/Match formula. Or is there a better formula when I don't know the column position of the header? The new report we get now, the header name is not always in the same order so the index/match formula isn't cutting it anymore. Example...
  2. B

    Use AVERAGEIFS based on dynamic criteria

    I'm trying to average a set of cells based on multiple criteria (hence the AVERAGEIFS), but I want this average to change as more data is added. There may be a very simple fix for this, but I can't figure it out for the life of me. Below is a sample of the table followed by an explanation of...
  3. W

    Prevent a dynamic line chart from interpreting formula output of "" as 0?

    I have a formula in a table that uses an IF function. The output of the formula dynamically plots a line chart. The problem I'm experiencing is that if the output of the IF function is False, then the "" value output is interpreted by the dynamic line chart as a zero instead of a blank cell...
  4. A

    Referencing controls on a userform that was created dynamically

    I have created a Userform programmatically and created a series of controls on the form. Now I want to read from/write to one of the text boxes. I have tried everything that I can think of to reference to the control, but I'm having no luck. The control was originally created as part of the...
  5. D

    dynamic range HORIZTONALLY

    i know veritfically (ie offset($a$1,0,0,counta(....) but how do you make one horizontally for 2 rows. also, is it possible to make a dynamic range formula that expands BOTH veritically and horizontally?
  6. D

    Creating dynamic reference from another workbook

    I want a drop down list in one workbook that references a dynamic list in another workbook ie it may have entries added to it so I can't hard code the reference? If I select data validation for a cell, I set it to allow a list but what do I put in the source for the list to be from another...
  7. T

    GET PIVOTDATA #REF! - Error

    I want to use the GET PIVOTDATA function to reference data fromwithin a Pivotable. When I enter: =GETPIVOTDATA("Amount",'2019'!$R$4,"Fund","1100","Orgn","2002","Acct","5815"),I get the result of $15,589.15 I want the function to be dynamic and retrieve the informationdisplayed in the Acct...
  8. C

    Dynamic Graphs, as columns are added daily

    Hello, I have searched online and in the forum for this answer. Everything I find only references is you have a table, or data within two columns, and you are adding additional rows of data. My scenario is that I have my dates as my headers/labels, and my data name/header is in column A. As...
  9. A

    Making the formula Dynamic based on Date Range

    Hi All -- I was hoping you can help me make the following formula dynamic based on a date range.. I have this formula : =INDEX(LINEST(I62:I73,J62:J73),2)*12 I have a table of dates (end of month dates) and two columns with numbers which I need summed up based on the most recent 12 months...
  10. M

    Dynamic Pivot Table/Macro Question

    Hi, I have created a macro for a table I made. Macro works fine, except when I refresh my dataafter running the macro, my data file changes from: =OFFSET(DATA!$A$1,0,0,COUNTA(DATA!$A:$A),COUNTA(DATA!$1:$1)) to: =OFFSET(DATA!#REF!,0,0,COUNTA(DATA!#REF!),COUNTA(DATA!$1:$1)) I do not know what...
  11. MannStewart

    Need macro for OFFSET whcih derives ROWOFFSET from a variable in another cell

    Hi I have a worksheet with a working range of B5:B5000, G2:G5000, H2, V5:V5000. where, V5:V5000 is just =ROW($B5)...downwards, $G$2 contains a function formula that returns a daily overall air-pollution level in decimal value that I make it recalculate each time the worksheet is...
  12. G

    Dynamic Indirect Reference

    I want to make a dynamic Indirect formula. My goal is to take a cell reference for a sheet, and also a reference of a cell on that sheet. So far I have this in cell B2: =INDIRECT(B$1&"!O2") Cell B1 is January. I want to reference the cell O2 in the January Sheet. This works, however, I want...
  13. G

    Dynamic Indirect Reference

    I want to make a dynamic Indirect formula. My goal is to take a cell reference for a sheet, and also a reference of a cell on that sheet. So far I have this in cell B2: =INDIRECT(B$1&"!O2") Cell B1 is January. I want to reference the cell O2 in the January Sheet. This works, however, I want...
  14. D

    pivot filter based on range

    right now i have this... With pf For Each pi In pf.PivotItems If pi.Name = "811" or pi.name = "911" Then pi.Visible = True Else pi.Visible = False End If Next pi End With but i'd like this to be more flexible and dynamic...
  15. S

    Creating a Dynamic Floor plan

    This is not looking for a solution its more so advice on if its possible. Was looking to create a dynamic floor plan in Excel where on the raw tab you would enter certain dimensions of a piece of equipment and it would then map it on a sheet. Something like Item A being 6*3 meaning its 6...
  16. D

    using lastrow perhaps

    i have the following code in a vba macro which works just find if I always insert the two cell numbers before executing the macro. (where the values are) N25 and M21 My intent is to build a dynamic string and store it in Column A:Lastrow+10 Can I somehow make them dynamic and use the last...
  17. G

    Dynamic print range VBA

    Hey there, I am trying to create a macro that will "read" the range from a cell such as "02" (A1:M39) and export that range as a PDF, however I have only been able to set the range directly in the VBA code, is it even possible to have it read a range that changes dynamically? For comparison...
  18. M

    How to get sum to jump 3 columns

    Hi, I got the following issue I run into. I want to sum one row at a different tab for each quarter. For example SUM(A20:C20) and then in the next column cell I want to get SUM(D20:F20) and the next column SUM(G20:I20). How can I do this efficiently in a dynamic way? Appreciate your help!
  19. A

    Dynamic Pivot: Value Filter Between

    Hello, I am looking to use inputs in my excel to alter a pivot table to show only the values between the min and the max inputs. I have the below code but the highlight part is where I fail. How can I reference the values? It produces a "Unable to get the PivotTables property of the Worksheet...
  20. Belair58

    Dynamic Formula for Percentages

    Hello, I have a sheet that I've created a blank row after each change in Column J. I need to have column P in that row to have the formula, but dynamic values for the column O should be dynamic : =ROUND(COUNTIF($O$2:$O$1007,"Late")/COUNTA($O$2:$O$1007)*100,2) at each blank line. I've got the...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top