splitting large worksheet by dates
Posted by jason on September 05, 2000 12:56 PM
I have been assigned the dubious task of setting up an Excel spreadsheet for another employee to use. My group maintains a large list that shows part defects by date. Currently we have one master list (named 'MASTER') that has the date the problem was identified (in mm/dd/yy format), along with a half dozen other columns that contain pertinent information.
We analyze all of the data by months. It would be ideal if there was a way to automatically extract all the data by months into seperate worksheets with appropriate names like mm/yy.
I would like to be able to have the worksheet setup so that whenever the sheet named 'MASTER' is modified, the data is automatically split up, while still maintaining the master list. Since data does not always come in chronologically, I would need it to update all of the sheets (including adding new ones whenever a month occurs that is not accounted for).
Thanks so much,