software

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

Nothing built in, you need to write your own function or macro (or let
somebody else do it)

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)quot;Kate at workquot; lt;Kate at gt; wrote in message
...
gt;I want to extract certain rows of data (there is a few thousand of them)
gt;from
gt; the spreadsheet I'm working on. These particular rows have a coloured
gt; fill.
gt; The end result being a new spreadsheet containing only the data from these
gt; specific rows. Other than the coloured fill there is nothing to
gt; destinguish
gt; these rows from any of the 8000 or so in the original spreadsheet.
gt; I'm using Office 2003Thanks Peo
regards
Kate

quot;Peo Sjoblomquot; wrote:

gt; Nothing built in, you need to write your own function or macro (or let
gt; somebody else do it)
gt;
gt; www.cpearson.com/excel/colors.htm
gt;
gt; you can install the function that returns colorindex for instance, use it in
gt; a help to return the colorindex and then apply autofilter and filter on the
gt; help column and finally copy the visible cells and paste somewhere else
gt;
gt; --
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; (No private emails please)
gt;
gt;
gt; quot;Kate at workquot; lt;Kate at gt; wrote in message
gt; ...
gt; gt;I want to extract certain rows of data (there is a few thousand of them)
gt; gt;from
gt; gt; the spreadsheet I'm working on. These particular rows have a coloured
gt; gt; fill.
gt; gt; The end result being a new spreadsheet containing only the data from these
gt; gt; specific rows. Other than the coloured fill there is nothing to
gt; gt; destinguish
gt; gt; these rows from any of the 8000 or so in the original spreadsheet.
gt; gt; I'm using Office 2003
gt;
gt;