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...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top