Hi,

I have seen this in a spreadsheet before but can't work out how it has
been done.

Row 1 has had a filter applied to it and one of the columns is filtered
as to only display say "open" records.

In the next column when placing the cursor on the cell a little filter
symbol (filter downward arrow ) appears in the bottom right hand corner
of the cell showing a list of data options available for that column.
You can then select one of these to change the data.

Can anyone help me here ?

Cheers,
Bernz


--
BernzG
------------------------------------------------------------------------
BernzG's Profile: http://www.excelforum.com/member.php...o&userid=22949
View this thread: http://www.excelforum.com/showthread...hreadid=527860