Only visible cells copy when filters applied

[handerson0603]

I have an Excel 2007 spreadsheet with several hidden columns, from which I copy and paste into another spreadsheet with the same structure. I want to copy the hidden cells so everything lines up on the new sheet. However, when I use Autofilter to select the rows I want, then highlight those rows and select Copy, only the visible cells are copied. If I remove the filter and manually select the same rows, all the hidden data copies.

I want to copy the columns that I have hidden manually, but I do not want to copy the rows that the filter has hidden automatically. Is this possible, or do I just have to find another way to work?

 

[BrianB]

looks like a macro to temporarily unhide the column, copy, hide the column & paste ... ?