Copy Entire Rows of filtered data onto another table

[AntoniioBindi]

Hello

I've been struggling with a VBA solution for this and would appreciate your valuable help.

I have a named table range, whose headers are on row 14. I need to filter its contents and move filtered data to another table. Number of filtered rows will always be variable, but will always start in row 15.

Manually, it would look like:

1 - Filter the table based on column B criteria
2 - Select all the filtered (visible) ROWS (remember table headers are in row 14, and there ARE used cells above that, just not belonging to the table or named range)
3 - Cut (Ctrl-X) the selected rows
4 - Paste copied rows in row 15, shifting down, in another named table / spreadsheet

I find an issue even doing it manually, as I can't "Insert Copied Cells" by clicking on the row number, if copied rows are non-contiguous, nor can I "copy cells here, then shift rows down" inside a table.


Any light?


I do have a dumb workaround for the manual process which consists in Pasting copied rows on cell A1 of an empty sheet (will be pasted in contiguous manner) and manually select all rows, cut and only then paste of final table.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...red-table-onto-another-table.html#post5198864

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.