Splitting data into separate worksheets

**Supernowsky** · 06-22-2012, 11:24 AM

Hello,

I have a classic problem that I have found addressed a few times before in different threads here, but always for a slightly different version than the data I am working with. I receive a regular feed of data and need to sort by 'Sector' (first column), then split out into individual worksheets via a MACRO - while retaining the sheet with total data.

The complete dataset contains several other columns that I have omitted for confidentiality reasons, so any Macro would need to be versatile enough to traverse my entire sheet and include all active columns. The average feed size per day is 10-15k rows and does not come pre-sorted.

I have included a sample set of my data. Any help would be greatly appreciated!!

Thanks,

Dan

**arlu1201** · 06-22-2012, 11:40 AM

You need to explain some more - for e.g. -

1. On what basis should the data be sorted? In other words - based on which column?

2. If you have already run the macro once and the data has been split between the sheets, and you run the macro again, do you want the data from the sheets to be cleared and fresh data input? Or should the data be appended at the base of the existing data?

**Supernowsky** · 06-22-2012, 01:19 PM

Thanks very much for the quick reply, but with some more diligent searching I found a workable solution. Jerry Beaucaire posted a great generic MACRO that was easy to tweak to fit my dataset:

https://sites.google.com/a/madrocket...eet1-to-sheets

Much appreciated!