Blog

24
Jan

Matching and Merging Check Details in Spreadsheet & Screenshot

Post By admin

Project Title: Matching and Merging Check Details in Spreadsheet & Screenshot

Project Description:
I have two lists:

1. A spreadsheet with a list of checks (check number and check amount).
2. A folder with screenshots of checks. Each screenshot is the front of the check.

What I need is for someone to go through every screenshot in that folder and:

1. Find the corresponding check in the spreadsheet. All you need to do is make sure the check amount and the check number match (both have to match).
2. In the corresponding row, write the name of the check payee into that spreadsheet.

Also the spreadsheet lists 1,126 checks but the folder has 1,137.

I don’t know where the discrepancy is but there should be 11 screenshots that don’t have corresponding lines in the spreadsheet. I’d like you to write down the names of those files separately.

For similar work requirements feel free to email us on info@datacleaningservices.com.

  • Facebook
  • Twitter
  • Google Plus
  • Linkedin

Add a comment