How to match Date and Amount from Sheet1 to Sheet2 with the same Date and Amount?

Originally Posted by tehneXus

Hi,

try this:

Please Login or Register  to view this content.

Regards

umm.. what is Option Explicit for?

Try the attached

Originally Posted by AB33

Try the attached

what's the other sheet does? if it was deleted, the script wont work..

I'm kinda confuse..

There is no other sheets. I just copied sheet1 as original to check my code and it works. The code deals with sheets1 and 2. Just delete the other sheets if you want.

It is not only you would have encountered out of range errors, but lots of others errors too. You not only have changed the layout of the sheets, but you have lots of hidden columns and merged cells. It took me a while to notice these changes.
I have got two results sheets, but I believe the last one is the correct one. You have lots of empty cells in the amount column and If I were to include them on the code, I got some weird results. The correct sheet is sheet/13, but I have also include another sheet with zeros just to show you what you get if I were to include all amounts with zeros, hence I left them out.

Originally Posted by AB33

It is not only you would have encountered out of range errors, but lots of others errors too. You not only have changed the layout of the sheets, but you have lots of hidden columns and merged cells. It took me a while to notice these changes.
I have got two results sheets, but I believe the last one is the correct one. You have lots of empty cells in the amount column and If I were to include them on the code, I got some weird results. The correct sheet is sheet/13, but I have also include another sheet with zeros just to show you what you get if I were to include all amounts with zeros, hence I left them out.

ohh.. thats not actually just empty cell, i just removed some confidential notes in it and just left the numbers in it.. actually first, i will locate the checks.. after the checks.. i'll be locating the ones that does not have check.. i already have the scripts for the ones that have checks.. i'm having trouble with the ones who's only basis is dates and amounts (in which case, it should not grab the ones with check even though date and amount matches it, since its a different mode of payment)..

I'm really greatful for your help.. I'm still reviewing the script.. sorry if it's a little bit complicated.. I'm just hoping macro could help me lessen my job since i'm actually overloaded with one and i'm usually staying at the office untill 9 or 10pm while having a little time to sleep and relax..

Please do not reply with quote, just reply will do.
I believe excluding zeros would be correct. If two cells have Blank, but have the same date, the code will treat them as a match and such would return a value, despite there is zero values on the credit side.

ooh.. sorry.. I don't really know the effect of replying with quote or none..

wow you do really know a lot.. how were you able to study this? I'm having hard time trying to understand the scripts..

how can you make it cut and paste? instead of copy and paste? the previous script i had i was able to change copy from cut.. but from your script.. i don't see any copy script that i could replace it with cut..