I have a spreadsheet of shortpayment amounts and their invoice numbers on one
spreadsheet with a column of credit amounts with their invoice numbers on
another spreadsheet. I need to match the credits written with the
shortpayments.
kinda like this
spreadsheet 1 spreadsheet 2
inv # amount date Credit #
Amount Date
122334 15.00 11-25-09 675555 15.00
12-10-09
223345 22.00 10-20-09 754444 22.00
111-25-09

naturally there is a huge list with some credits only close to inv. short
pays with some short pays with no credits etc. but if I can match the same
amounts it would be a huge time saver.