i15

  1. N

    How does subtotal formula updates automatically with insertion of new rows?

    I have subtotal formulas at different rows of columns I. That is at I15 (I9:I14), I18(I16:17), I32(I19:I31). when I insert a new row, the formula at I15 updated to accommodate the new cell however the formulas in I18 an I32 resist t change for any new insertion between the range and the formula...
  2. M

    VBA to cycle through cells

    Hi I have 2 buttons one for cycle left and one for right. i would like to be able to cycle the selection forward and backward. I15, AN15, BP15, CU15, DY15, FD15, GH15, HM15, IR15, JV15, LA15, ME15. Thanks in advance.
  3. W

    VBA Copy Range and Past till Last Row

    What code do i use to do the following? Copy range I2:I14 Paste from I15 to Last row(based on column A). Thanks.
  4. S

    Using SUMIFS to multply a cell

    I am trying to write a formula that will multiply the value in cell I15 by 5 if that cell is at 20 or more, and if cell I16 is equal to or higher than 105.95 and display the result in cell K15 In other words, I input 19 or less into cell I15, K15 shows 0 I input 20 into cell I15 and if cell...
  5. E

    Shift/Sort Related Data By Formula Containing Column When New Record Found

    Hello Wonderful People, I hope the title makes sense.... In this workbook I have names in column C (C12:C312). The names are a concatenation of adjacent cells from two columns (first names and surnames) in another linked workbook (sorted by surname) and don't cover the whole range - there 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 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