consolidate historical stock returns from multiple workbooks into oneworkbook

L

Lucas Simmons

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/tutorial...f-98f78bf38458/eggheadcafe-in-silverligh.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Consolidate CSV files with historical returns for stocks in onespreadsheet 1
Excel query insert 1
Calculating a worksheet 3
Macro to Combine Data from Multiple Sheets with Cell References 4
countifs 1
extracting multiple rows of data from another worksheet 1
Copy and paste same cell from a number of sheets into a new sheet 3
Copying specific cell ranges from a worksheet multiple times to a newsheet 3

Top