You could either add a column with a unique value added to each line where
you highlighted it and do the autofilter thing as mentioned, or you could
use VBA (automation). For the VBA method, you would need to specify what
color you highlighted it or what the condition(s) are to get highlighted.

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAM


"ED" wrote in message
...
I have a price sheet which is about 100 pages long. I have to do
inventory.
We only stock about 25% of the items. So I went along and highlighted all
the stocked items. Now I would like to create a copy of all the
highlighted
numbers to a new sheet so only the stocked items are listed for inventory
purpose.



"Pete_UK" wrote:

How are the rows highlighted? If you have applied Autofilter and you
then highlight all the visible cells, then you can click <copy and
paste them into another sheet - only the data that you have highlighted
will be copied.

Hope this helps.

Pete