Forum Discussion
Excel Copy All Columns Even When Table Is Filtered
I have a table (Parts Library) with a couple of hidden columns (so that columns match the BOM sheet), when I have no filters applied to this table I can copy and paste from it, and it copies the hidden cells as well. When I DO filter the table, excel seems to skip over these columns.
Is there a way to avoid skipping over these columns?
Is there a work around for filtering which WOULD let me copy those columns?
Thanks!
One of workarounds is to use VBA. Another workaround is to copy filtered cell with the column next to it. Let say we have such table
If copy filtered data only visible cells will be pasted
If copy with prior column, but include header row, all data will be pasted
One of workarounds is to use VBA. Another workaround is to copy filtered cell with the column next to it. Let say we have such table
If copy filtered data only visible cells will be pasted
If copy with prior column, but include header row, all data will be pasted
Thank you for this, realistically I think this is going to be the best option. I am just going to add a small 'A' column outside of the table on both the source and destination sheets.
