copy formula

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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 =...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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 = _...
  15. 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...
  16. 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...
  17. P

    Macro to insert row/column and copy the formula from the preceding row/column

    Hi, I have quite a complex macro question to ask (at least in my mind anyway :rofl:), but seeing as though people on here like a challenge i thought i'd post it: First of all see screenshot of my spreadsheet for reference: What i am trying to do is to create separate macros to do the...

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