Quote:
Originally Posted by OCM
Is it possible to get the filtered records (not allowed) in a separate sheet by itself? If not, what you provided is suffice.
|
Select the whole table, the Cut (Ctrl+x) and paste to the new location (Ctrl+v).
It's better to
cut rather than
copy because you'll get a copy of the query too which is unnecessary.