I have built my own money management tool using Excel. I would like to take Quicken download data and output this data in four columns (type of transaction, date, description, and amount). My credit card company allows download in csv format, but my bank only alllows Quicken and Money downloads. I have no need for header info that comes with the download.
I have managed to extract transaction data to get it into the 4-col format. However, I have to dump onto one worksheet, manually add rows where transaction take up less than 7 rows. Then, I copy this data onto another sheet that extracts, format, and dump data into the four columns. Whew, it make me tired trying to explain it. Is anyone aware of VBA code that can simplify this process.
Terry
I have managed to extract transaction data to get it into the 4-col format. However, I have to dump onto one worksheet, manually add rows where transaction take up less than 7 rows. Then, I copy this data onto another sheet that extracts, format, and dump data into the four columns. Whew, it make me tired trying to explain it. Is anyone aware of VBA code that can simplify this process.
Terry