Paste ignores cells hidden with autofilter. Btw, it is very bad practice to have several different tables on same sheet, especially when those tables share same rows. Paste to another sheet, or at least into range below original datarange.