+ Reply to Thread
Results 1 to 3 of 3

Read .csv file data

  1. #1
    Registered User
    Join Date
    05-03-2010
    Location
    Tennessee
    MS-Off Ver
    Excel 2007
    Posts
    9

    Read .csv file data

    I have been on a mission to get my financial life to stay in the green, it's been in the red
    so much because of my inability to track my money. What I have came up with is an Excel sheet that looks and acts exactly like a checkbook register.

    a1=date B1=refrence C1=description d1=debits e1= cleared f1= credits g1= balance

    Starting in g3 through end of that that colum I use this formula =G2-D3+F3 to do my
    calculations, I only have to fil in a, b, c, then either d, or f depending on the transaction. All this works well but I have to sit and go through each transaction online and enter "C" in colum E of my sheet to mark each item cleared or not, either way colum G will still show me the actual balance since it doesn't matter if the item is clear or not.

    What I am trying to do is come up with an Excel formula to read NOT import data from a .csv file and compare it to my sheet. I can download my statement in .csv format that looks like this when opened with Excel.

    a1=date b1=refrence c1=description d1=amount e1=cr/dr **the cr=credit and dr=debit.

    If I could get a macro that would allow me to select the .csv file I downloaded then scan it
    for matching credits or debits on my spreadsheet and if it finds one then automaticaly put a "C" in my spreadsheet colum E next to the matching transaction then I wouldn't have to go through it searching for the matches myself. I make more mistakes than humanly possible when I try to do this.

    Is anyone available to help me come up with such a macro, I would greatly appreciate it and I wouldn't be less than broke all the time.

  2. #2
    Registered User
    Join Date
    05-03-2010
    Location
    Tennessee
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Read .csv file data

    Just a thought to maybe help with your thoughts..... what if the macro would open another instance of Excel in the background/unseen, load the .csv file then compare data in it's colum D against my spreadsheet colums D and F and if it finds a match then automaticaly put a "C" in colum E then after it's finished it would close the background/unseen instance of Excel.
    Last edited by kistonce; 05-08-2010 at 09:01 PM.

  3. #3
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Read .csv file data

    kistonce
    hard to say maybe
    Please Login or Register  to view this content.
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

+ 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