Thread: Split table into smaller tables & into different worksheets each
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Split table into smaller tables & into different worksheets each
Pradeep

How are you able to do a custom sort/filter on colored cells?

Are you using a UDF like Chip Pearson's SortbyColor function?

http://www.cpearson.com/excel/SortByColor.htm

Or do you mean the red, green, yellow is text in the cells?


Gord Dibben MS Excel MVP

On Thu, 3 May 2007 05:24:02 -0700, 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?

Reply With QuoteReply With Quote