Same as before as far as code placement. If U hit the button enough times before the code would eventually produce a result. Dave
Same as before as far as code placement. If U hit the button enough times before the code would eventually produce a result. Dave
Nice Dave. Works great. Thanks.
Peace of mind is found in some of the strangest places.
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
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.
Trial changing this line of code...
I think you're pastings strings. DaveTotNum = TotNum + CDbl(Sheets("Sheet1").Range(InCol & RowNum))
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