dynamic range autofill

I´m having trouble creating a rolling chart regarding the syntax of the OFFSET Function for specifying a dynamic range. i want to make the table so that. when a new column header is added, the same values of previous collumns are added bellow this new collumn header aswell. I´m doing this by...

Hi Team, I am very new to VBA so please be gentle. I am trying to automate a lengthy process that I do everyday and I have recorded a macro to help me do the same. One part of the process involves filtering a set of names and replacing said names with one common term. the code - given below...

I'm looking to create a line chart that automatically updates when a new row of data is entered, but I only want the line chart to display the last 30 data points from the column titled "Error (Bias)" Is this possible to create using Excel? I am using a Windows PC and Excel 365.

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,new to VBA so I was hoping someone could help me out. I've looked through this website and online and can't find a solution. The below Macro will run on different tabs so it will go through columns of different row numbers. Therefore, I need to make my SUMIF and ranges Dynamic so they...

I have a chart that changes dynamically with data that is entered on another sheet. I then make a scatter plot from this chart. The data goes from 0 to a maximum value (which is what is always changing) then returns back to zero. I want the graph to ignore the returning or down slope of the...

Hello Everybody, I need your help in correcting this code. I need a range from specific row to specific column. The row and column has to be dynamic as it changes everyday. I have been through few posts on this but nothing what fullfilled my requirement. Code: 'Last Column Dim col As...

Hello from an unexperienced vba user.. I'm having trouble with the code for autofill to the last row when trying to use named ranges for the column. Everything seems to work fine when I use a hard coding for the column, in this case Column CW, and what I need is to replace this column CW...