b13

  1. E

    Priority Formula help

    Hello All, I am trying to create a survey that results in a priority. Here's the detail. I have 10 questions, each answer is to be entered as a number (0 = no, 1 = not sure/maybe and 2 = yes) After answering them all, I have the total in a cell, lets call it B13, which will be anything from 0...
  2. I

    Run macro only if 2 criteria apply

    Hi, I am currently using the following code supplied. It works fine as it should but i have noticed that if the cell B13 has no value the macro still runs. Please can you advise an edit to add to the supplied code so not only must cell B13 be active BUT it must also contain a value Sub...
  3. I

    Clear value once active cell is then not active

    Morning, Can you be of assistance to alter the following code supplied. I wish to clear contents of the active cell B13 once its no longer the active cell. Have a nice day. ​Sub sbClearCellOnlyData() Range("B13").ClearContents End Sub​
  4. M

    Formula help

    Hi Again, I have another formula giving me trouble ... (LOL) =IF(B13="FT",(F18/37.5*C20),IF(B13="contract",(F18/37.5*C20),IF(B13="PT",52.5))) The formula works as is BUT I want it to do this instead: If B13=FT (F18/37.5*20) if B13 = PT enter 52.5 If B13 = Contract AND D13 = PT then enter...
  5. F

    Range("B" & Rows.Count).End(xlUp).Offset(1)

    Hi Guys, This is probably an easy fix, but I've been struck on this for a while now. Range("B" & Rows.Count) - This will give me the last available row in column B, but I need the paste to start at range("B12"), then B13, B14, B15 etc... Any suggestions? Thank you, FP
  6. K

    Create tabs using filtered pivot

    Hello, I have a sheet with two pivots. I want to create the same sheet using different departments per tab (cell B1 and B13). Is it possible to create a code to auto create the tabs? Image of sheet attached

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