Create New File at a Page Break

[cchaney]

So I have a file and have inserted page breaks in at certain intervals. At every change in the data in a particular column can Excel extract the corresponding rows, and create a new file using the particular column data as a file name? Does that make sense?

Thank you,

Chris C.