update formula

  1. Sufiyan97

    Easiest way to update formula

    is there any easiest way to update below formula as per expected? AB1RawExpected2='PL Trend'!C10=SUM('PL Trend'!C10:D10)3='PL Trend'!C11=SUM('PL Trend'!C11:D11)4='PL Trend'!C23=SUM('PL Trend'!C23:D23)5='PL Trend'!C33=SUM('PL Trend'!C33:D33)67
  2. M

    Formula results not updating when inserting cells

    Basically, I have a formula that checks to see if the text of one column is within the text of another. Pretty simple. However, when I insert cells then the formula does not automatically update even though I have it set to Auto Update. Here's a short video of the problem: Screen Recording...
  3. C

    Modifying a formula from VBA

    I'm very new to VBA and never really used Excel for calculations. That said, I've managed to get some VBA scripting working in a workbook, with the help of a few people from this forum...
  4. victorcarreto

    refreshing formula in a column

    I’ve a Macro to split a cell and shift cells down, as the following: Sub SplitCell() Dim s As String, v As Variant, l As Long s = ActiveCell.Value v = Split(s, vbLf) l = UBound(v) - LBound(v) + 1 If l > 1 Then ActiveCell.Offset(1, 0).Resize(l - 1, 1).Insert Shift:=xlShiftDown...

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