g13

  1. I

    Worksheet activate question

    Morning, I have this is place at present. Private Sub Worksheet_Activate() Range("G13").Activate End Sub How can it be changed so i also see the 12 rows before it on the page. I mean sometimes even though cell G13 is selected its could be 1 inch down from the top of the page & i then...
  2. O

    Multi level ifs function

    I'm working in Excel 365 and I have a multi level if function that I'm having trouble figuring out. I'm not sure how to write the formula. I want to add: IF G12 is blank and G13 is blank use AA7 IF G12 not blank and G13 is blank use AA8 IF G12 is blank and G13 is not blank use AA8 IF G12 not...
  3. P

    macro that will copy ONLY the value I have in cell I1, and then paste it to another cell based on the cell reference I declared in cell G13

    Good day All, Hope all is well. Could you please help me have a macro that will copy ONLY the value I have in cell I1, and then paste it to another cell based on the cell reference I declared in cell G13. For example: I1 = “expired” G13 = C38 With this, I would like to see the value...
  4. djl0525

    Timesheet calculations

    In column F, I have Hours Worked. This number is usually 40, but it could be anywhere from 20-60. In column G, I need to find how many hours they worked between 37.5 and 40. If F13 says they worked 39 hours. G13 should return 1.5 (because 39 - 37.5 = 1.5). If F13 says they worked 40 or more...

Watch MrExcel Video

This Week's Hot Topics

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
Top