dynamic range

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...

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...

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...

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...

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)

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

Please help, I have been scouring the internet for 2 days and cannot find the answer! I want to populate a userform listbox that has 2 columns which is looking at a dynamic range on another workbook. I have managed to populate the first column, which is column A, but cannot make it look at...