Hi "Toppers",

I am doing exactly that right now - want to do something to simplify my work.

The problem is that I have a huge database which I need to split. Doing a
custom filter some 30-40 times (since I have 40 odd "Colors", so to speak,
for which I need to creat separate tables) is tedious, time consuming and
there is a lot of scope for error while copy-pasting.

Pradeep

"Toppers" wrote:

Why not filter on colours and cut/paste to relevant worksheets.

Less than 5 minutes work even for very large table as the filter will select
your records for copying..

"Pradeep" wrote:

Hi,

I have data in a workbook that I need to split into different sheets.

I have a table that has (say) 500 records each for (say) colors Red, Green
and Yellow (totally 1500 records) in one table. This table needs to be split
into worksheets, and each sheet to have records only for each colour. I know
I can do a custom sort (for say records not equal to Red and Green) and
delete the non-relevant records, but I need to do this for very large tables.
Any help?