LinkBack URL
About LinkBacks
Hi,
i have attached my problem in the excel sheet.
I trying to check for tally match:
set A number = Set B number and if match,
check if the set B's number amount added up = set A number amount
Thanks!
Hi,
i have attached my problem in the excel sheet.
I trying to check for tally match:
set A number = Set B number and if match,
check if the set B's number amount added up = set A number amount
Thanks!
Maybe:
Please Login or Register to view this content.
Hi John,
I run the macro, it should match the number and the total amount.
example E2 and E5 number = TRIU 1234567 with total amount of 21.0+1.50=22.50, should match with A2 with amount is 22.50 too.
Try this.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Glad it works and thanks for adding rep points.
Hi Bakerman2,Originally Posted by bakerman2
Glad it works and thanks for adding rep points.
Can modify the code, add that
if the column A and column E number match and column B and F total amount also match = TRUE
Because current code, if the column A having duplicate numbers, it will take as not match with column E.
Thanks
Last edited by okl; 08-18-2016 at 12:49 AM.
Test this.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks