Cross file 'capturingupdating

[Adam Brown]

Hi,

I'm not sure if this is possible - but hope of you guys can tell if it is!
I have a csv file (we'l call it file1), updated daily, that lists lottery results in this format:

Row 1: Megamillions, Date, 1,2,3,4,5,6
Row 2: Powerball, Date, 2,3,4,5,6,7
etc

I also have for each lottery its own csv file which lists all the historical results for each lottery (we'll call these files 2,3,4,n etc), in this format:

e.g. File2, megamillions.csv
Date, 1,2,3,4,5,6
Date2, 2,3,4,5,6,7
etc.

e.g. File3, powerball.csv
Date, 2,3,4,5,6,7
Date2, 3,4,5,6,7,8
etc.

I'd like somehow to automatically update files 2,3,4,n etc with results data from file 1. This would involve automatically 'checking' file 1 everyday, extracting the results data and inserting as a new row in file 2 - then repeat for data in file 3,4,n and so on.

Is this possible in any way possible in Excel?

Many, many thanks!

[arlu1201]

Right now your question is a little vague. Why dont you explain with the help of a sample file or files?

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[Adam Brown]

Thanks for the advice Arlette. I've now attached 3 files, file1results, file2mega and file3powerball. These correlate with the files I mentioned in the first post.

The results data in file1results (e.g. all data in columns C-H) changes everyday. As soon as the data changes I'd like the new data to be "captured" and entered as a new row, in row A, in the respective results file. In other words as soon as cells C1-H1 in File1Results changes, I'd like a new row to appear in File2Mega with the new data from File1 to be populated in it. I'd like the same to happen for File2Powerball with its respective data and so on. This will in time automatically grow the size of files2,3 etc.

Hope this makes sense!
Many thanks.

FIle1Results.xlsFile2MegaMillions.xlsFile3Powerball.xls