Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
extracting data to csv from multiple worksheets
I have a spreadsheet containing fund and benchmark performance data
over a fiver year period (60months). There are a number of funds (approx 20), each stored on individual worksheets with the fund shortname as the worksheet name. I need to write a macro that will extract all of this data and insert it into one large csv file which will then be imported into a sql server table. The number of periods(months) and dates are excatly the same for each fund and therefore the cell range to be extracted are also the same across each worksheet (A5:D65). The first cell on each worksheet also contains the fund shortname. Questions a 1. How can extract cells A5:D65 from each worksheet into one large xlcsv file? 2. For each fund added I need to add the fund shortname as the first column for each period (month). The fund shortname is currently stored in cell A1 on each worksheet. I am a complete novice at this so I hope this makes sense. Thanks Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link multiple worksheets while extracting data | Excel Worksheet Functions | |||
Extracting Data from Multiple worksheets to a single worksheet | Excel Programming | |||
extracting data from other worksheets | Excel Worksheet Functions | |||
Extracting data from multiple worksheets into a list | Excel Worksheet Functions | |||
Extracting data from one row across multiple columns | Excel Programming |