consolidate historical stock returns from multiple workbooks into oneworkbook
 

Hello,

I previously posted this in the miscellaneous group, but realize it is more appropriate here.

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
EggHeadCafe in Silverlight Release Candidate Now Available
http://www.eggheadcafe.com/tutorials...ilverligh.aspx

consolidate historical stock returns from multiple workbooks into one workbook
 

Try my add-in
http://www.rondebruin.nl/merge.htm

Or see the code links on the bottom of the page

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Lucas Simmons" wrote in message ...
Hello,

I previously posted this in the miscellaneous group, but realize it is more appropriate here.

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
EggHeadCafe in Silverlight Release Candidate Now Available
http://www.eggheadcafe.com/tutorials...ilverligh.aspx