autofill columns

I'm trying to auto fill given financial periods based on start and end dates of agreements, this will then allow me to prorata the contract value. Contract Period A1 Start: 15/02/2020 A2 End: 14/02/2022 Auto Fill = A3 FY19/20 Start = 01/02/2020 A4 FY19/20 End = 31/03/2020 A5...

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 have a table similar to this: I have a formula in Column A2. I want to transfer it and use it automatically for the whole column. However, I tried possible and impossible ways to do it, but none of them worked. I also looked at forums such as. here: vba to drag down formula/data from last...

Hello Every one, please help me with the proper VBA code for this: My work sheet has two Columns A and B I need to Auto fill Dates monthly starting from the last date in column B till the end of the last filled Cell in Column A. the last cell on both columns needs to be dynamic since the...

Hi I have different formulas in 1106 columns relating to the 1st row (Column B) There are up to 500 rows where data can be put in. This can lead to a lot of formulas, as I have up to 20 sheets of this. The 500 rows are not always used, and I do not want unused formulas in the sheets this is an...

I currently have this: Dim lastrow As Long Dim lastcol As Long Sheets("Template").Select Range("v13").Select lastrow = Range("S" & Rows.Count).End(xlUp).Row lastcol = Range(11, Columns.Count).End(xlToLeft).Column Range("V13").Formula = "FORMULA HERE" Range("V13").AutoFill...

I have a spreadsheet containing different groups of data, each of which vary in number of lines, separated by single blank lines. The number of groups also varies from month to month. I can find the last line of a particular group using 'SelectionEnd(xlDown).Select' with no problem but i don't...

Hello Experts, I have a situation where there are few rows for which I should paste date from Workings column to the last column of that Row. Refer below example for clear understanding, ID 1st Case 2nd Case 3rd Case 4th Case 5th Case Working A1...

This is a part of my code: The purpose is to go to the first empty cells in the row 2 and row 3 and then type specific formulas and then autofill in that particular column.(here from L3 to L13) Sub AutofillTable1() 'go the first empty cell in the 2nd row and type Median...

I am trying to write a macros so that a given column will autofill a given range based on the last cell. Below is an example to better explain what I need: Michael Michael Richard Richard Tyler Sam Sam Billy Billy Chad Chad Pretend these given names are all in the same column (lets...

I am working in VBA and am having an issue trying to get my information to copy down a formula until there is no data. The ranges of which to copy down changes so cant do a certain range. I have the formula in cell S4 and want it to be filled down. I am basing the data off column E that is 14...

Hey, so I'm trying to use the AutoFill with Cells command an I am having trouble. Here is my code Range("L2").Select ActiveCell.FormulaR1C1 = "=(DATEVALUE(RC[-1]))" Selection.NumberFormat = "m/d/yyyy" Selection.AutoFill Destination:=Range(Cells(2, 12), Cells(lastRow2, 12))...

Need some help I want to have Column A auto fill based on what zone is entered in A1. I am having some problems right now as my formula has become really long the way I been trying and does not work for all Zones. is there an array or another type of formula? <tbody> Thanks...

I was wondering how - if possible - I can go about using the autofill method to fill to the end of the column if the column isn't necessarily specified, but referenced. It's harder to explain than it is to see so here's what I'm working with right now. I just started using VBA a couple of...

Hi, I have specific columns where I input values manually - the rows are constant so always from B11 to Q38 and down to row 72 (B-Q). The inputs are values in tonnes that I would like to convert to kilograms by adding three 0. However, some of the cells are also text cells which should not have...

i have this pattern GRB1F GRB2F GRB3F GRB4F Is there a way to drag it down so it continues as GRB5F GRB6F ? please help. i have hundreds to do and dont want to do them one by one:confused:

I'm trying to autofill a range in Sheet1 with an formula that calls data from Guests (another worksheet in the same workbook). But I need it to end at the last row of data from the Guests worksheet. The macro runs currently, but I don't want to have to change the range every time. And this macro...

Hello everybody. I'm new to the forum and to macros as well. I'm sorry to bother you with such an easy question but I can't figure out how to solve this problem even if i spent hours on it. This is the code : Sub HLLE() Range("E" & Cells.Rows.Count).End(xlUp).Select Range(Selection...

I have a workbook that will have over 20+ tabs and I am wanting to build a macro to do an autofill to last active cell in the current column I have selected. What is the correct code? I have this currently but it doesn't work (obviously :)) The only thing consistent will be that the formulas...

Hi, I have a macro I (with a ton of help) wrote a while ago to auto fill a column based on a value in another column. Here it is: ElseIf Not Intersect(Target, Columns("C")) Is Nothing Then Dim tmp As Range Set tmp = Sheets("Client No...