| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Split table into smaller tables & into different worksheets each
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to split a cell in Excel 2003, just like in Word Tables | Excel Discussion (Misc queries) | |||
| Creating a macro that will split data into different worksheets | Excel Discussion (Misc queries) | |||
| i want to open large file 300 col, how to split between worksheets | Excel Discussion (Misc queries) | |||
| How to split worksheet to make smaller | Excel Worksheet Functions | |||
| split results to multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
