Copying entire from filtered table 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.

 

[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.
If you looking for a popular aviator games like jet-x or lucky jet I can advice you Aviator Play online – Авиатор игра онлайн на деньги, Авиатор 1win where you can find detailed explanation about how to play in aviator online on various platforms.

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.

Ok, I fixed that