Highlighted

[ED]

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.

 

[CLR]

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

 

[Pete_UK]

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

 

[ED]

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.

 

[Zack Barresse]

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.

 

[Ron de Bruin]

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