Hi
I have a workbook that has numerous entries and what im trying to do is check them against each other.
On sheet 1 & 2 In column A I have numerous numbers and what im trying to do is at every change in column A I need it to do a auto sum and then do the same thing in sheet 2 and compare them to see if the totals the same. If they are not I then need it to go through every entry in list and highlight the duplicates or missing entries in sheet 1.
Workbook attached and hope that makes sense. The other thing is the numbers will not all be in the same order on both sheets so you would probably need to filter out by using filter function and then selecting each number before doing sum and comparing
When you click on link it shows as a PDF but then click on download and it will convert to excel.
https://my.pcloud.com/publink/show?code=XZX6jG7ZTuGcbk8vCE77Q8RjrVXUMS9u0iky
I have a workbook that has numerous entries and what im trying to do is check them against each other.
On sheet 1 & 2 In column A I have numerous numbers and what im trying to do is at every change in column A I need it to do a auto sum and then do the same thing in sheet 2 and compare them to see if the totals the same. If they are not I then need it to go through every entry in list and highlight the duplicates or missing entries in sheet 1.
Workbook attached and hope that makes sense. The other thing is the numbers will not all be in the same order on both sheets so you would probably need to filter out by using filter function and then selecting each number before doing sum and comparing
When you click on link it shows as a PDF but then click on download and it will convert to excel.
https://my.pcloud.com/publink/show?code=XZX6jG7ZTuGcbk8vCE77Q8RjrVXUMS9u0iky
Last edited: