Consulting

Page 2 of 2 FirstFirst 1 2
Results 21 to 26 of 26

Thread: Formula help

  1. #21
    VBAX Expert Dave's Avatar
    Joined
    Mar 2005
    Posts
    832
    Location
    Same as before as far as code placement. If U hit the button enough times before the code would eventually produce a result. Dave

  2. #22
    Moderator VBAX Master austenr's Avatar
    Joined
    Sep 2004
    Location
    Maine
    Posts
    2,033
    Location
    Nice Dave. Works great. Thanks.
    Peace of mind is found in some of the strangest places.

  3. #23
    VBAX Expert Dave's Avatar
    Joined
    Mar 2005
    Posts
    832
    Location
    Once again austenr, you are welcome. You may need to adjust the "200" iterations dependent upon the amount of data. Have a nice day. Dave

  4. #24
    Moderator VBAX Master austenr's Avatar
    Joined
    Sep 2004
    Location
    Maine
    Posts
    2,033
    Location
    Hi Dave been playing around and testing it some more. Im running into a problem if you copy and paste over the numbers in col A and you are certain that you have those invoices in that list that match the total and run the function it does not come back with any matches. However if you clear the numbers and input them manually it works. Am I missing something.

    Also should note the numbers i am pasting to the workbook are from a csv file if that matters.

    Also if you save the workbook as an xlsx file the copy and past the numbers it works. Not sure why.
    Peace of mind is found in some of the strangest places.

  5. #25
    VBAX Expert Dave's Avatar
    Joined
    Mar 2005
    Posts
    832
    Location
    Trial changing this line of code...
    TotNum = TotNum + CDbl(Sheets("Sheet1").Range(InCol & RowNum))
    I think you're pastings strings. Dave

  6. #26
    Banned VBAX Regular
    Joined
    Feb 2020
    Posts
    8
    Location
    I'm confused. There's multiple ways of adding up to the number in C2. So, pretty much all of the numbers could have an "X" beside them.... depends which ones U want to add together. Dave

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •