PDA

View Full Version : Spreadsheet data management



jalea148
07-24-2012, 08:05 AM
My workbook has a Main spreadsheet and 20 Other sheets. All are ordered by date with the latest date at the bottom. Each row of Main refers to the corresponding row and the previous row of the Others.

Here's a simplified example.8510 If any of the CSV files have data after 7/23/2012 it needs to be imported.

Each of the Other sheets is a duplicate of a corresponding CSV file that is automatically updated daily. These files have 5 columns and about 1500 rows. In each Other spreadsheet the location of its corresponding CSV file is stored in H1.

What is the way to keep ALL the sheets up to date daily? When the spreadsheet opens [or a macro is executed] the bottom of the 20 CSV files need to be examined.
For each of the Other spreadsheets
Read its corresponding CSV file
If there are dates after the last date in the spreadsheet then append those rows to this spreadsheet