F
FMS
Hi there
I'm having trouble with a block of data in a spreadsheet that has Automatic
Data Filters on. When new data is added to the blank rows at the bottom,
these are not then picked up when I filter any of the criteria - i.e. at the
bottom of the filtered list I get rows which do not fulfill the filter
criteria.
I definitely don't have a blank row, so I know it's not that. I'm sure I've
not had this problem before.
The spreadsheet is used by others with limited Excel experience so I don't
want to have to ask the to take the filters off and reapply them each time
they add new data.
Any assistance gratefully received.
I'm having trouble with a block of data in a spreadsheet that has Automatic
Data Filters on. When new data is added to the blank rows at the bottom,
these are not then picked up when I filter any of the criteria - i.e. at the
bottom of the filtered list I get rows which do not fulfill the filter
criteria.
I definitely don't have a blank row, so I know it's not that. I'm sure I've
not had this problem before.
The spreadsheet is used by others with limited Excel experience so I don't
want to have to ask the to take the filters off and reapply them each time
they add new data.
Any assistance gratefully received.