lowndes783
New Member
- Joined
- Nov 9, 2005
- Messages
- 3
When i use autofilter to filter my data it changes, the first few columns are correct but the data that is stored in the later ones doesn't move so is wrong.
e.g.
before sorting
column1 column2 column3
Tom Hanks Good
Pete Tong Wrong
Walace Gromit And
after sorting on column1
column1 column2 column3
Pete Tong Good
Tom Hanks Wrong
Walace Gromit And
e.g.
before sorting
column1 column2 column3
Tom Hanks Good
Pete Tong Wrong
Walace Gromit And
after sorting on column1
column1 column2 column3
Pete Tong Good
Tom Hanks Wrong
Walace Gromit And