Search:

Type: Posts; User: willow1985; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: Looking for a more elegant way to write the following countifs formula

    That works. Thank you very much :)
  2. Re: Looking for a more elegant way to write the following countifs formula

    =COUNTIFS('WO Report'!$E:$E,Z2,'WO Report'!$S:$S,$B$12,'WO Report'!$S:$S,$C$12,'WO Report'!$S:$S,$D$12)

    This formula does not work but is there a reason why?

    the reason I ask is that this...
  3. Looking for a more elegant way to write the following countifs formula

    Hello,

    was wondering if anyone could help me with the below formula. Is there a more elegant way of writing it rather than adding each additional section?

    I want the formula to count E:E if it...
  4. Re: VBA move print area down 1 row from active cell

    Played around a bit and so far this is working:


    .PageSetup.PrintArea = _ .Range("Print_Area").Offset(2).Resize(.Range("Print_Area").Rows.Count - 1, _
    ...
  5. Re: VBA move print area down 1 row from active cell

    Actually this does not work. It is still moving down one row more than I need. Not sure how to adjust it that it moves to the selected cell...
  6. Re: VBA move print area down 1 row from active cell

    Nevermind, figured it out:


    With ActiveSheet .PageSetup.PrintArea = _
    .Range("Print_Area").Offset(0).Resize(.Range("Print_Area").Rows.Count + 1, _
    ...
  7. Re: VBA move print area down 1 row from active cell

    My mistake, the selected cell actually ends up just below the page break line so this code actually moves it one row lower than required. How could I adjust this code that it is even with the...
  8. VBA move print area down 1 row from active cell

    Hello,

    I was just wondering what would be the code to adjust a print area down 1 row without using specific ranges?

    I currently have a macro that finds the end of a table and adds a row for new...
  9. Replies
    5
    Views
    149

    Re: Drop down box value to trigger macro

    Works perfectly, thank you so much! :)
  10. Replies
    5
    Views
    149

    Drop down box value to trigger macro

    I have drop down lists in column O where you can toggle the status from "blank", to "open" to "closed".

    What I would like to do is have a certain macro run every time the status is changed in any...
  11. Re: VBA Run-time error '13': Type Mismatch

    I think you are right. I was given the code.

    I removed the last portion and changed it to the following. Appears to be working now. Thank you very much :)


    Dim lo As ListObject
    For Each...
  12. VBA Run-time error '13': Type Mismatch

    Hello, I have this code that I am not sure how it works but it appears to to a certain extent.

    What I am looking to do is insert a row at the end of a table. I have other data right below the...
  13. Re: VBA for verifying whether a specific worksheet and cell have data or not

    Works perfect! Thank you very much! :biggrin:
  14. Re: Not sure if a COUNTIFS formula is the way to go

    This appears to be working! Thank you very much :)
  15. Re: Not sure if a COUNTIFS formula is the way to go

    Both of the formulas are returning a count of 0
  16. Not sure if a COUNTIFS formula is the way to go

    Hello,

    Can anyone help me with a formula that counts invoice dates?

    Not sure if CountIF can do this or not

    Basically count how many items were invoiced in the current month and then another...
  17. Replies
    3
    Views
    65

    Re: #VALUE error with Sumifs formula

    I must be tired. Thank you very much!
  18. Replies
    3
    Views
    65

    #VALUE error with Sumifs formula

    Hello,

    I do not know what is wrong with the below formula - receiving a #Value error:

    =SUMIFS('WO Report'!F2:F1000000, $B$14,'WO Report'!V2:V1000000,$B$12,'WO Report'!S2:S1000000)

    Let me...
  19. Re: IF function for returning month name with data that has zeros

    Thank you guys! This is great info :)
  20. Re: IF function for returning month name with data that has zeros

    I figured out my error. This formula works but if anyone can let me know if there is a more efficient one that would be greatly appreciated. The data will always come in with zeros...
  21. IF function for returning month name with data that has zeros

    Hello,

    I have a column that has a list of "0" and dates.

    I am looking for a formula that will return the Month name on any cell that does not contain the text "0" and if it has a "0" return a...
  22. Re: Sum one column for all cells that have the previous day/current month/previous month in another column

    Thank you very much! :)
  23. Replies
    4
    Views
    158

    Re: Modify SumIf formula

    Thank you all very much! :)
  24. Replies
    4
    Views
    158

    Modify SumIf formula

    I have this SumIf formula that Sums column G if the dates in Column F Match the previous day:

    =SUMIF('WorkOrder Search Export'!G2:G1000000, TODAY()-1, 'WorkOrder Search Export'!F2:F1000000)

    How...
  25. Re: Text and Data reference formula in a text box

    This works. Thank you very much :)
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4