Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i copy only the coloured filled rows in excel to new sheet
I want to extract certain rows of data (there is a few thousand of them) from
the spreadsheet I'm working on. These particular rows have a coloured fill. The end result being a new spreadsheet containing only the data from these specific rows. Other than the coloured fill there is nothing to destinguish these rows from any of the 8000 or so in the original spreadsheet. I'm using Office 2003 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i copy only the coloured filled rows in excel to new sheet
Nothing built in, you need to write your own function or macro (or let
somebody else do it) http://www.cpearson.com/excel/colors.htm you can install the function that returns colorindex for instance, use it in a help to return the colorindex and then apply autofilter and filter on the help column and finally copy the visible cells and paste somewhere else -- Regards, Peo Sjoblom (No private emails please) "Kate at work" <Kate at wrote in message ... I want to extract certain rows of data (there is a few thousand of them) from the spreadsheet I'm working on. These particular rows have a coloured fill. The end result being a new spreadsheet containing only the data from these specific rows. Other than the coloured fill there is nothing to destinguish these rows from any of the 8000 or so in the original spreadsheet. I'm using Office 2003 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i copy only the coloured filled rows in excel to new sh
Thanks Peo
regards Kate "Peo Sjoblom" wrote: Nothing built in, you need to write your own function or macro (or let somebody else do it) http://www.cpearson.com/excel/colors.htm you can install the function that returns colorindex for instance, use it in a help to return the colorindex and then apply autofilter and filter on the help column and finally copy the visible cells and paste somewhere else -- Regards, Peo Sjoblom (No private emails please) "Kate at work" <Kate at wrote in message ... I want to extract certain rows of data (there is a few thousand of them) from the spreadsheet I'm working on. These particular rows have a coloured fill. The end result being a new spreadsheet containing only the data from these specific rows. Other than the coloured fill there is nothing to destinguish these rows from any of the 8000 or so in the original spreadsheet. I'm using Office 2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Can I copy data from only the visible rows in Excel? | Excel Discussion (Misc queries) | |||
Edit / Move or copy sheet stopped working in Excel 2003 | Excel Worksheet Functions | |||
Macro - to copy duplicate rows to another sheet | Excel Worksheet Functions | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) |