copying filtered data WITH the hidden columns

**noraaa** · 07-04-2012, 02:20 AM

hi all,

I have some data of which some are hidden columns. I have filtered some of it and would like to *cut* the filtered data INCLUSIVE of the hidden columns.

I noticed that i'm able to *cut* WITH the hidden columns when i didn't use the filter function. But once filter is on, the hidden columns are not copied.

I have tried to search for answers in the forum and google but all of them seem to be solutions to copy the filtered data WITHOUT the hidden columns.

appreciate the help of any kind souls out there...

**GazP** · 07-04-2012, 03:10 AM

Clear the filter, copy and paste, reapply filter on pasted and original data?

**noraaa** · 07-04-2012, 04:28 AM

Originally Posted by GazP

Clear the filter, copy and paste, reapply filter on pasted and original data?

hi there,

sorry i may used the wrong words. i'm actually CUTTING and pasting the filtered data out to another sheet. ultimately, i do not want the filtered data in the original list anymore.