I would like to create a new sheet from an existing sheet, but I only want
to see the highlighted rows.

Is this possible?

Thank you.

If the rows are all highlighted because of a certain value in one column,
then you could do Data Filter AutoFilter then select that value in the
dropdown at the top of that column.......this will filter the data to only
show those rows of interest........then copy and paste them to a new
sheet.......

hth
Vaya con Dios,
Chuck, CABGx3



"ED" wrote:

I would like to create a new sheet from an existing sheet, but I only want
to see the highlighted rows.

Is this possible?

Thank you.

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

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

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

Check out EasyFilter
http://www.rondebruin.nl/easyfilter.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"ED" wrote in message ...
I would like to create a new sheet from an existing sheet, but I only want
to see the highlighted rows.

Is this possible?

Thank you.