copy formula

Good morning community! I have copied and modified the next VBA formula from a YouTube video: Range("G2").Formula = "F2*0.2" Range("G2").AutoFill Range("G2:G16") The formula, of course, works just fine, copying the formula to cell G16. I modified it as follows: Sheet3.Range("I3").Formula =...

Hi! I'm new to the forum and was wondering if someone out there could give me a little guidance. I recently watched the linked Youtube video which detailed how to add a new line containing data into a table using a macro button. Whilst the video was great and was incredibly helpful I am still...

Hi guys, Ik have found this it does almost what i need to do. There is a formula row R11:Z11. VBA wil find the last empty rows and paste the formula there. The problem is that it does copy the exact row numbers starting row R11 then R12 etc. I need it to just copy and use the row numbers where...

hello I have a macro that automatically creates column headings based on a Lov list I have within the workbook I also have worksheet2 that contains formulas that I would need copied over to the new columns in worksheet1. example: Each time a new column header is in inserted it is inserted...

Hi all! I currently have this setup, please note that I have hidden all the nonrelevant columns however: The formula I use is this (thank you @RoryA !) =IFERROR(INDEX(INDIRECT("'"&H504&"'!$U$3:$U$73"),MATCH(1...

Hi, brand new to MrExcel; I tried searching for previous posts about this but I'm not sure I'm asking the question correctly; so I apologize if this is listed elsewhere. I have a formula in G5 of that I want to copy down to G50: =SUM(INDEX('Material by Mo.'!$D2:$O2,MONTH(TODAY()))*'Material...

Hi all, I already read some threads in this big forum but didn't find what I am looking for. I hope it is ok to ask for some help on this: I have a table and a button to click in A1. If I click this button, a new row shall be inserted below the current active cell including only the above used...

Hi, I am a bit rusty on excel and wanted to check how you would suggest I complete the below. I have a spreadsheet with various sections so for example Rows 3 to 6 are one section, rows 7 to 10 are another and 11 to 14 are another. I want to add a button to click in each section to add an...

Hi mates, I would like to seek help on building some Macro. I have a table for end user data input, let's say monthly record of sales figure. For example, row 2 is the first record, while B2, C2 & D2 are for end user's data input, and E2 is a formula. I would like to create a Macro fro...

Hey Guys, I am inserting the formula but having trouble getting it to copy down. I want it to copy down to the last row of column AA to account for variable data. Sub Insert_QueryTitle_Formula() Range("AA1").Formula =...

My problem is frustrating especially because I know there has to be an easy fix. I have columns of peoples information (name, birthdate ect) and I am looking to print it out. it is formulated like this: <tbody> First Name John Jane Jim ect Last Name Doe Doe Doe ect... Birthday...

I'm trying to make the button find the last instance of a non-empty cell in column B, then select the row between (B:L) from the last non-empty cell in column B. Copy the format and formula in the selection then insert a new row below and insert the format and formula. The reason I'm not using...

I have 138 Excel Workbooks with 12 sheets each. That’s 1656 sheets I need data from plus 4 totals from each, so in total I need 6624 formulas. The Sheets are named 1-12, and the workbook names are "Last name, First name." I need $J$15, $J$16, the sum of $J$15:$J$16, and $K$22 from each sheet...

Hello! It's been a while since I've posted in this forum and after searching through MrExcel and online I can't find a way to make this work. I have reference data in Column D of a workbook that I need copied over to other columns, but not every one of them. For example I have dollar amounts...

I have a master sheet and 20 sub sheets. I input data in the master and it filters through to the 20 subs and calculations are done. the problem is that on the master there are blank cells, that need to remain blank cells until i put the data in. This data is copied to the subsheets using a...

Hi all, In my sheet called Data, cells Y2:BF2 contain formulas. At the moment, I've been manually dragging the formulas to copy them down all my data. I only need to copy them down as far as the last cell with data in column V2, but where this last row is will keep changing. I was wondering...

Good morning, I have the following code which works but only fills down one row and I want it to fill down to the last row but I cannot work it out. Dim Col As Range For Each Col In Range("L:Q").Columns With Cells(Rows.Count, Col.Column).End(xlUp) .Offset(1).Formula = .Formula...

Hi Guys, Right now this is the VBA I have. Instead of copying the formula down to FG403 all the time, I need to copy it to the last active cell (cell with data) in column A. Thanks for the help Range("FG33").Select ActiveCell.FormulaR1C1 = _...

Hello I have a simple macro to copy a row and insert below. Works like a charm. However... Sub AddRow() ' ' ' ActiveCell.EntireRow.Copy ActiveCell.Offset(1, 0).Rows("1:1").EntireRow.Select Selection.Insert Shift:=xlDown End Sub This alters the formulas relative...

Hello, I am looking to copy a formula down a column range, but I only want the formula to be copied until the last cell with data. Essentially, I'm trying to use some type of untilblank() functionality. I need to do this for about 7 - 8 columns in the worksheet, and each of the formulas are...