Previously, I have done an Advanced Filter query, with the Extract in the same Workbook, and:
1.) Sorted the Extract
2.) Made some changes to the Extract
Sometimes this had a bad effect: With whatever change I made, it did the same thing to the rows above and below it - unwanted changes
Other times: There was no effect that I noticed
So, at the moment, I just know that it's not a good idea to change data within the extract,
but I'm not sure why
and, I'm not sure why I can change data in some cases.
I was wondering, what are the rules for making changes in the Advanced Filter extract? Is there a page that explains it somewhere?