+ Reply to Thread
Results 1 to 1 of 1

Excel 2007 : Excel 2007 and SAP downloads

  1. #1
    Registered User
    Join Date
    07-08-2011
    Location
    Houston, TX
    MS-Off Ver
    Excel 2007
    Posts
    1

    Excel 2007 and SAP downloads

    My ERP system is SAP. Every month, we download budget versus actual information for analysis. The data feeds to a summary spreadsheet. To locate new general ledger account numbers that come on during month, we have a list of standard account numbers in column A in Excel 2007. We copy and paste the data out of SAP. We then check to see if new account numbers have come into play by scanning down Column A and making sure the account number in that column matches the account number in the column just downloaded.

    A very manual effort to say the least.

    434245 434245 Sale Cap-Vehicles
    434505 434505 PY Expend Recovery
    * 434 - Miscellaneous & Other
    441010 441010 Signatory Landings 69,357,014.00-
    441015 441015 Carrier Incentive Program 334,394.00-
    441020 441020 Aviation Fuel Revenue 217,250.00-
    441030 441030 Aircraft Parking Revenue 1,509,750.00-
    * 441 - Landing Area 71,418,408.00-

    If the account numbers don't line up, we have to figure out what was added.

    Is there a simpler way to do this? I've attached an example.
    Attached Images Attached Images

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1