ExcelBanter - Break Up Data

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Break Up Data (https://www.excelbanter.com/excel-worksheet-functions/212437-break-up-data.html)

I'm trying to take a very large spreadsheet and make it into several
spreadsheets. I want to divide it at every change in a certain column. Sort
of like sub totaling, but instead of a sub total, I want it to all move to
another sheet. Is this possible?
--
Jennifer

On Dec 3, 4:05*pm, Jennifer
wrote:
I'm trying to take a very large spreadsheet and make it into several
spreadsheets. *I want to divide it at every change in a certain column. *Sort
of like sub totaling, but instead of a sub total, I want it to all move to
another sheet. *Is this possible?
--
Jennifer

Sure. You could:
-Move it manually. About a hundred different ways.
-Write VBA code to move it automatically. Probably using
AdvancedFilter.
-Write referencing formulas in the new spreadsheets to pull the data
in.

Pretty hard to say more unless you give more information. Like what
format is the data? How many sections are there to move? Are there
formulas already that need to be kept?