dynamic range

  1. sdrowsick

    VBA Loop Issue

    Hello! I'm new here, so please let me know how I can best improve for future posts... My question is about a VBA loop in a file. I am trying to create a program that takes all the cells in a range (the range is a dynamic named range, but for this example, it's 269 rows and 37 columns), checks...
  2. M

    Sum Levels of Nested Subtotals

    Hello, I am trying to write a macro that sums several layers of nested subtotals. The lowest level subtotals (subtotal 2) are already calculated and pulled from another tab. Subtotal 1 needs to ONLY be the sum of the individual Subtotal 2 lines. In my example below, the first subtotal 2 field...
  3. G

    Dynamic Range that expands with new columns

    I am trying to create a dynamic range that expands with new columns added. I created a defined name called ("DynamicCompList") and the range for this is D7:R57. When I enter information into S7, I want the range to expand to D7:S57. My data in the range has some blanks that need to stay. I tried...
  4. G

    Add data to dynamic range

    I have a dynamic range that expands when I add new data(naturally). I would like to add code to a button that I have that will adddata to the range when the button is pressed. This is the line of code I amworking with: Sheets("Competitor OverviewData").Range("CompetitorsLOV").Offset(1, 0).Value...
  5. A

    Dynamic range name when it starts in a row > 1? Counta() does not work for me!

    Excel friends, I would like to setup a dynamic range name for B9:C20. I have tried out too many online examples using Counta(), but those examples do not work for me. B9:C20 starts in row 9, and it is two columns wide. Variations of this formula do not work for me...
  6. A

    Dynamic range for columns in a pivot table

    Hi all, I am trying to create a dynamic range to accommodate when the number of rows and columns can change in the data set when creating a pivot table. I created a named range but I cant quite get it to work. Any help please.. =OFFSET('Waterfall 23'!$A$2,0,0,COUNTA(Waterfall '23'!$A:$A)1,1)
  7. C

    Dynamic range that needs to be parsed, then reaggregated.

    I really would appreciate some extra eyes on this, I’m thoroughly stumped. Let me know if you have any questions or clarifications. I have a daily reconciliation with 4 unfortunately un linked data sources. Thus far I have created a macro that can handle 3/4 sources but I've hit a wall on the...
  8. K

    Clear Contents below a dynamic Range

    Hi everyone hopefully this is a simple one but my limited VBA experience has me stumped. I want to clear the contents of columns a and b when a is blank. Below is the table of sample data i want to clear cells a4:b7, however this range need to be dynamic based off if column A is blank and b...
  9. A

    Counting entries from dynamic range

    Hello all, I am writing a simple macro to count the number of categories in a dynamic range by: Offsetting the bottom of the range (“SectionInfant”) by -1 CountA the resulting range (B4 to Target) Paste the resulting number in F1 I can’t get the following code to work. Any help is...
  10. M

    Chart Dynamic Range

    Hello, Using Excel 2016. I created a chart with a chart data range from B2:F13. I created a macro that will insert a column in C:C. This causes my chart data range to now =B2:B13,D2:F13. The new data in column C is not being displayed on the chart. I have a screenshot, but I'm unsure how...
  11. N

    VBA to Select Dynamic Range

    Good morning, I have a workbook with 3 sheets of similar format. Each returns data starting in cell "P3:W" but can return a different number of rows on each sheet. For example, SheetA returned 5 rows so I would need to select "P3:W7" but on SheetB there is only one row so I only need to select...
  12. A

    Pull Index/Match/offset from a Range data then Sort Numbers with Points

    Hi, I'm tryng to Index Match from a Dynamic Range of 6 pairs of columns, The column work as: Col A= Numbers, Col B=Values Col C= Numbers, Col D=Values Col E= Numbers, Col F=Values Col G= Numbers, Col H=Values Col I= Numbers, Col J=Values Col K= Numbers, Col L=Values Notes: -.Numbers on each...
  13. S

    Creating a VBA function for index and match with dynamic named ranges ... Urgent please help!!!

    Afternoon, I am hoping someone can help me with this. I have lots of dynamic index and matches needing to be placed in one formula and it is getting very long and messy. As a result, I need to create functions for each one of them to shorten the formulas. I am struggling to get the below...
  14. M

    Copy/Paste Row from another workbook based on selection in a dynamic ComboBox

    I have a combobox that populates with a dynamic list of check numbers based on the employee selected in a listbox. The check number values in the combobox change each time a different employee is selected in the listbox. These check numbers are "imported" from different worksheets in another...
  15. V

    To use countif in a dynamic column using dynamic row range

    I have a data set of employees with their Present absent details. I want to use countif of A and P in the last column of the data set. I am not sure in which column the last data will be present as sometimes we take 2 months data etc. after finding the last column I want to add a coutif in all...
  16. M

    Loop through cells until blank

    I am trying to create a utility that will execute my code until the first blank cell in Column 1. The rows are dynamic and I have a marker cell that will move with the Header Column. I have concept code right now to test that it will actually work and when I run the code nothing is happening not...
  17. S

    Trying to COUNTIF with OFFSET 1 row to Last Row

    I've spent 4+ hours trying to figure this out without success. Simple Record Macro works: ActiveCell.FormulaR1C1 ="=""Cards issued this week ["" & COUNTIF(R[1]C:R[15648],""Yes"") & ""]"" " But I can't get figure out how to revise the code into a dynamic range. I've tried several versions, for...
  18. N

    Sum alternate columns with dynamic range

    I have a excel sheet having monthwise sales (qty and value) in column against each item in row. I need to sum the alternate column (i.e qty and value seperately). I am using the formula "=SUMPRODUCT(--(MOD(COLUMN(D4:AA4)-COLUMN(D4)+1,2)=0),D4:AA4 " which gives total of all the qty and value...
  19. J

    Printing Dynamic Pivot Table

    I have 3 pivot tables on one worksheet that provide end users 3 different views of the department data they want to see. The end user selects the department and the data is filtered for the selected department. I want to provide the end user the ability to print the pivot table data if they...
  20. R

    SumTotal from dynamic range

    Hi All, Facing a problem which (again) I cannot figure out. I need to SumTotal(or add up using any other function) numbers which could appear in different columns and can have a dynamic range(the numbers needed to be totalled can be anywhere from row 1 - 10,000) If helps, the numbers will...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top