How are the entries highlighted?

By coloring manually all the same color?

One method.........................

Select all cells.

EditFindFormatFormatPattern.........pick the pattern and "find all"

After the finding and with the "found" dialog still open hit CTRL + a to
select the founds.

EditCopy then paste to another worksheet.


Gord Dibben MS Excel MVP


On Fri, 21 Aug 2009 07:15:01 -0700, Carol330
wrote:

I have a spreadsheet (50 pages). 4000 line entries. I have severaal hundred
highlighted. Is there a way to pull just the highlighted.