insert a row of formulas

  1. W

    VBA code to add repeat formula to each blank row

    Hi there, I'm trying to add a formula into each blank row of my data set in column C. (see cell C5 on image, as an example of where the formula has populated, and cell C11 where it hasn't) The formula in column C is a weighted sum product formula i.e. =($B3*C3)+($B4*C4)+($B5*C5), so this...
  2. H

    Copy multiple rows and insert multiple times

    Hi Everyone Probably about a month or 2 ago I was able to copy a few rows and insert them on my desired location multiple times. Does anyone know if this was just an update or a tick under some or another setting? The rows copies has formulas in them thus the clipboard would not work for this...
  3. A

    HELP needed at insert a number of rows!

    Hi guys! I have a problem! I have a cell with a number and I need to insert in a table that number of rows. If I have 5, I want to tell excel to introduce 5 rows, if I have 2 I want to tell excel to introduce 2. How can I do that with VBA and Excel? For example: <tbody> A B C D E F G...
  4. R

    Insert Row below current row when...

    I want to insert a new row with the existing formulas that I have in the current row. I want this row to be below the current row and I want it to insert when data in column A is changed from empty to a selection from a dropdown list. Can anyone help with this?
  5. G

    macro needed to pull information from one sheet to another and then insert specific text in the cell above

    Please be patient with me as this is my first post. I am looking for a macro that will do the following... In tab B when I insert a specific 3 digit number (which resides in tab A, column B with full detail) into column A; I want it to pull the description associated with the number into tab b...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top