LISTS- adding info without repeat to other lists
 

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.

LISTS- adding info without repeat to other lists
 

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