evaluating text of cells
I'm trying to select certain cells base on availability.
eg.
on sheet 1 cell A1 has the text value "AgeLine (F)" the (F)
indicates it is available.
on sheet 2 I want a list of available items.
there are around 1000 cells on sheet 1 or which 150 are available.
any ideas on how to achieve the this list?
thanks
Glenn
|