Consolidate CSV files with historical returns for stocks in onespreadsheet

[Lucas Simmons]

Hello,
I need to consolidate historical stock returns into a Master worksheet of a Master workbook. The format of the destination Master worksheet needs to have the stock ticker at the top of each stock's respective data, with data consolidating from left to right.
I have 20 number of CSV files (one for each stock) each with one tab with the name of the stock's ticker all saved in the same folder. The data in each file has the same format: column A has the date and there are various open, close, etc data going out to column G (7 columns for each file).
I am new to VBA for Excel and have attempted some code, but would very much appreciate some help with this.
Thank you anyone who has an approach and is willing to help.
Best
LWS


Submitted via EggHeadCafe - Software Developer Portal of Choice
Dr. Dotnetsky's Cool .NET Tips and Tricks # 4
http://www.eggheadcafe.com/tutorial...b146-89d4f30844a0/dr-dotnetskys-cool-net.aspx

 

[Lucas Simmons]

I reposted this in the Excel Programming Group... please disregard




Lucas Simmons wrote:

Consolidate CSV files with historical returns for stocks in one spreadsheet
09-Jan-10

Hello,
I need to consolidate historical stock returns into a Master worksheet of a Master workbook. The format of the destination Master worksheet needs to have the stock ticker at the top of each stock's respective data, with data consolidating from left to right.
I have 20 number of CSV files (one for each stock) each with one tab with the name of the stock's ticker all saved in the same folder. The data in each file has the same format: column A has the date and there are various open, close, etc data going out to column G (7 columns for each file).
I am new to VBA for Excel and have attempted some code, but would very much appreciate some help with this.
Thank you anyone who has an approach and is willing to help.
Best
LWS

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Remotesoft Obfuscator, Decompiler, Protector
http://www.eggheadcafe.com/tutorial...71-1176e2aff3c7/remotesoft-obfuscator-de.aspx