Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.48 seconds.

  1. Thread: FIND Question

    by JoeMo
    Replies
    4
    Views
    68

    Re: FIND Question

    Maybe:

    =SUMPRODUCT((List!J:J<>"Project")*(List!Y:Y>0))
  2. Re: Automatically Move row from 1 worksheet to another when a cell value changes in first worksheet

    Welcome!
    Can you provide some additional information by answering the questions below?

    1. Where on "Prospects" do the client records begin (include the header row).
    2. Is the column named...
  3. Re: Run Time Error '13': Type Mismatch on time calculation

    You are welcome - glad we could help.
  4. Replies
    5
    Views
    93

    Re: VBA IF THEN with 2 conditions

    Bad syntax. Change this bit:

    If D.Value = Value.Interior.Color = vbGreen

    to this:

    If D.Interior.Color = vbGreen
  5. Replies
    4
    Views
    116

    Re: How to combine two table information?

    You are welcome - thanks for the reply.

    For EUR use same formula but change the ranges to adhere to the position of the raw data in the two tables.
  6. Thread: =IF Help

    by JoeMo
    Replies
    9
    Views
    174

    Re: =IF Help

    One possibility is that A5 and B4 look like they are the same but one or both have some extra spaces. In any empty cell enter: =EXACT(A5,B4)
    If that returns False try: =EXACT(TRIM(A5),TRIM(B4))
    ...
  7. Re: Found last used column from Row 2, need value in row 1

    You are welcome - thanks for the reply.
  8. Replies
    4
    Views
    116

    Re: How to combine two table information?

    You need to extend the ranges in the formula below to cover all 12 months. Here B9:E9 hold s the exchange rates for US to CAD.
    Sheet10


    <colgroup><col style="font-weight:bold; width:30px; ...
  9. Re: Found last used column from Row 2, need value in row 1

    The value in row 1 of "this column", assuming that's LastColumn is: Cells(1,LastColumn).Value
  10. Thread: Macro Help

    by JoeMo
    Replies
    2
    Views
    46

    Re: Macro Help

    Untested - may need some tweaking for path separator and spacing within the file name.


    Sub Filesplit()
    Dim sh As Worksheet, fName As String
    fName = InputBox("Enter file name prefix")
    If fName...
  11. Re: Copy data from worksheet and paste in same worksheet but at different range

    You are welcome - thanks for the reply.
  12. Replies
    3
    Views
    65

    Re: Changing time format

    Oops, it is. I was focused on transforming a number to text rather than the exact format requested. :banghead:
  13. Re: Sumproduct Isnumber Search is returning same result for different values

    Then replace the ISNUMBER(SEARCH ...) with this:

    ($H$11:$H$23733=2)
  14. Replies
    3
    Views
    65

    Re: Changing time format

    <b>Sheet9</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; ">...
  15. Re: Sumproduct Isnumber Search is returning same result for different values

    If there are spaces on either side of the 2 (or 7) change your search to:

    SEARCH(" 2 ",...)
  16. Re: Copy data from worksheet and paste in same worksheet but at different range

    This is a duplicate post.
  17. Re: Copy data from worksheet and paste in same worksheet but at different range

    Assuming your sheet tabs are in ascending order:


    Sub EOD()
    Dim i As Long
    For i = 4 To ThisWorkbook.Worksheets.Count
    With Sheets(i)
    .Range("B11:G150").Copy
    ...
  18. Re: Run Time Error '13': Type Mismatch on time calculation

    I think the red highlighted line will produce a type mismatch error as well. Replace with:

    NextTime = Now + TimeSerial(0,58,0)
  19. Replies
    4
    Views
    106

    Re: VBA hide last two rows in a table

    You are welcome - thanks for the reply.
  20. Re: Make macro work with upper case and lower case

    try:

    If Target.Column = 3 And UCase(Target.Value) = "ARRIVED" Then


    and similarly for the "DEPARTED" line
  21. Replies
    4
    Views
    106

    Re: VBA hide last two rows in a table

    Try this - change the table name to match the name of your table:


    Sub HideLastAndTotalRows()
    Dim LO As ListObject
    Set LO = ActiveSheet.ListObjects("Table1") ' change table name to suit
    With...
  22. Re: Keeping the "0" as the start of a string of numbers

    This returns a text string, not a number:
    <b>Sheet2</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff;...
  23. Replies
    5
    Views
    159

    Re: Whole circle bearing calculation with vba

    You are welcome - thanks for the reply.
  24. Replies
    5
    Views
    159

    Re: Whole circle bearing calculation with vba

    Can't help you with the answer produced,nor the validity of the equation you posted for whole circle bearing, but the method of calculation using VBA is what I wanted to convey.
  25. Re: Using Excel Filter to Search for text containing a comma & displaying all records that contain one

    You are welcome. That's a lot of terms to add. Would you be open to a VBA solution?
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4