copy formula

  1. C

    Drag Formula Down to Cell 100,000

    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 =...
  2. B

    VBA for adding data to new row in table whilst retaining 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...
  3. M

    Hi guys, need some help here!

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

    Copy formulas from one worksheet to another macro

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

    Have formula data appear as text, maybe VBA solution?

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

    Copy formula down a column that calculates cells across a row

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

    VBA: Insert row + keep formulas

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

    Insert Row copy formulas but not content

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

    Macro to copy specific section at the bottom of existing data set

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

    Inserting Formula and copying down to last row

    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 =...
  11. A

    Looking to do a simple copy 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...
  12. W

    Active X button, VBA to copy format and formula of above cells.

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

    copy formulas with workbook and sheet names as variables

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

    Copy formulas in a column to other column without incrementing?

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

    stop blank cells copying to 0

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

    Macro copy formulas down a specific range

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

    Finding last Cell and Copying down formula in multiple colums

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

    Copy Formula to last active cell in A

    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 = _...
  19. C

    VBA Copy formula without changing reference

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

    VBA Code toCopy Formula Down Column until No more data

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back