Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-23-2015, 10:59 AM
KSand KSand is offline Locating new information in daily reports Windows 10 Locating new information in daily reports Office 2013
Novice
Locating new information in daily reports
 
Join Date: Nov 2015
Posts: 1
KSand is on a distinguished road
Question 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?
Reply With Quote
  #2  
Old 11-24-2015, 07:34 PM
macropod's Avatar
macropod macropod is offline Locating new information in daily reports Windows 7 64bit Locating new information in daily reports Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply



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
Locating new information in daily reports 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:07 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft