Hi
Sorry if this sounds confusing but I have an excel document as a table with
written info in it, not for calculations or anything. On the second column
title there is a drop down list from which I can select to view all- or 7
different sections, a,b.c etc.
I click on c and add new rows and type the info in and save. Yet when I
click on a or b to view the lists for some reason this info I typed to list c
also appears there, although I specifically clicked to add to 'c' only and
labelled it accordingly in the column.
Please please can someone explain why it is doing this and how when I add
info to a set list, it will not then appear at the bottom of other lists.
Thanks.

The information that you added might be outside the range of the filter,
so it's always displayed. Perhaps there's a blank row between the new
data and the previous rows. If find and delete that row, the filter may
work correctly.

Jemimastar wrote:

Hi
Sorry if this sounds confusing but I have an excel document as a table with
written info in it, not for calculations or anything. On the second column
title there is a drop down list from which I can select to view all- or 7
different sections, a,b.c etc.
I click on c and add new rows and type the info in and save. Yet when I
click on a or b to view the lists for some reason this info I typed to list c
also appears there, although I specifically clicked to add to 'c' only and
labelled it accordingly in the column.
Please please can someone explain why it is doing this and how when I add
info to a set list, it will not then appear at the bottom of other lists.
Thanks.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html