| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Seperate out rows to make a new page in a workbook
In my workbook I have records for the years 2006, 2007, 2008. Since it is
sorted by client last name the dates are not sequential. I want to seperate out all the 2006 records and put them on a seperate sheet called 2006. Then I want to close the gaps so I don't have spaces in my speadsheet and the row numbers are in sequence. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Seperate out rows to make a new page in a workbook
Try Easyfilter
There is a option to do this in the add-n http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "relo" wrote in message ... In my workbook I have records for the years 2006, 2007, 2008. Since it is sorted by client last name the dates are not sequential. I want to seperate out all the 2006 records and put them on a seperate sheet called 2006. Then I want to close the gaps so I don't have spaces in my speadsheet and the row numbers are in sequence. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Do you have to make seperate layouts for Mac and PC? | Excel Discussion (Misc queries) | |||
| how do you make a summary page showing the workbook name with the excel sheet names | New Users to Excel | |||
| how do I make the first three rows repeat on top of every page? | New Users to Excel | |||
| how to make a workbook an interactive web page? | Excel Discussion (Misc queries) | |||
| make first few rows print on every page? | New Users to Excel | |||
Linear Mode
