DUE DATE 11/6 ESTIMATED HOURS 2.0-3.0 HOURS
1. The spreadsheets 1/2011 through 8/2011 are to be reformatted to look like Sheet 1 in the 1/2011 spreadsheet.
2. Then combine all the reformatted sheets into a single sheet for 1/2011 to 8/2011
3. Then sort & subtotal the combined spreadsheet by Payee
4. Create a Summary Report by Payee/Totals
5. Then go to the spreadsheet 9-12 2011 BBT 3721 and
(a) Add Payee- See the Description column to determine the Payee. If you disregard the numeric values, addresses or other words that are clearly not a NAME you should be able to determine the Payee name. If you cannot then just leave Payee blank.
(b) Sort by Payee. Do not subtotal at this point until I review your work.
6. Send spreadsheets back for my review.