#1
|
|||
|
|||
Locating new information in daily reports
I receive a daily report with monthly expenditures listed..but no date for the transactions. I would like to know if there is a way to compare these daily spreadsheets together to find the new information... which would be the spending transactions for the previous day. There is information in columns A-K, with columns E,G, & H holding the specific information pertaining to the expense (E-Account # billed, G- The amount of the transaction, H-Description of the sale). In case its helpful, there are 301 rows in todays spreadsheet, and a new transaction would be list in a new row.
Any suggestions? |
#2
|
||||
|
||||
Assuming there's a consistent structure to the workbooks, there is undoubtedly a way to do such comparisons and, so, identify the differences. Without actually seeing some representative workbooks, it can be difficult for anyone to advise on the specifics. Can you attach a some representative workbooks to a post with some representative data (obfuscate anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Locating and removing large, duplicate blocks of copy in word | markaffleck | Word | 2 | 06-05-2014 10:12 PM |
Locating current/actual contact form. | wdzambotti | Outlook | 0 | 09-10-2013 10:08 PM |
Daily Auto Print | bgreenfamily | Word | 5 | 08-29-2011 03:30 AM |
Automating daily process | dreww2 | Outlook | 0 | 06-28-2011 07:25 PM |
daily calender printing | ccronin4 | Outlook | 1 | 01-10-2007 12:47 PM |