I have a large amount of data in a worksheet that I have to split into separate worksheets. I'm wondering if there's a way to split into separate worksheets make a selection, rather than making a selection, clicking "insert worksheet" and pasting. The data is variable in the amount of rows and columns.

I've looked at Data Extraction Assistant (http://office.microsoft.com/en-us/ma...359651033.aspx), but I'm not sure. My columns values are all variable as well.

Any ideas?