+ Reply to Thread
Results 1 to 3 of 3

Feed .csv table into master ledger commodity prices

  1. #1
    Registered User
    Join Date
    05-08-2012
    Location
    Texas
    MS-Off Ver
    Excel 2003
    Posts
    20

    Feed .csv table into master ledger commodity prices

    Every day after the market closes I receive a file in .csv format via email to my MS Outlook. The file name has a unique date, and contains a list of commodities and their daily prices. The format of the columns and the rows are fixed and remain the same, all that changes is the date in the A column and the prices in the G column, each row is a different commodity.

    I would like to, in as few steps as possible, record these prices in a master ledger, whereas the commodities are listed as rows and the columns are the unique dates. Any help would be greatly appreciated. This is a mundane daily task I would like to automate as much as possible.

    Thank you.

  2. #2
    Registered User
    Join Date
    05-08-2012
    Location
    Texas
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: Feed .csv table into master ledger commodity prices

    ...Anyone?

  3. #3
    Forum Contributor
    Join Date
    11-11-2007
    Posts
    263

    Re: Feed .csv table into master ledger commodity prices

    It is possible, but without seeing anything that you are working with we can only guess what the CSV format or anything else looks like.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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