I am having a problem with autofilter in vba form. I have two documents linked together and when soemthing is typed in a certain cell everything is copied over to another sheet. When that word is deleted i want it to autofilter and delete the row that was previously copied. I can seem to get it auto sorted but it wont delete it. Any ideas?