Copying invisible columns, but not invisible rows

Well, what I'm doing is: I have a button that copies the current list of products we carry from our daily buy sheet and pastes it into an inventory sheet, laid out to be printed for counting. We're in the produce industry, so we take a daily inventory and what we carry fluctuates almost daily. This is a shortcut to update our inventory sheet with the click of a button to stop from having to manually edit it every time something changes.

The rows are the types of products, and the columns are various numbers related to how much we should be buying. The hidden rows are part of a script that adds a new type of fruit to the buy-sheet with the click of a button, so no time needs to be spent formatting anything. Essentially, the button copies the hidden row and pastes a copy directly above that hidden row, preserving the identity of all my named ranges and the formatting of that hidden row. These hidden rows have "INSERT NAME" written as the name of the fruit, and obviously don't need to be included on the inventory sheet. The hidden columns, on the other hand, are full of formulas that would clutter everything visually if they were visible on the buy-sheet, but the way they're formatted gives me the right layout when they're copied and pasted onto the inventory sheet (all the content after the names gets deleted after pasted onto the new sheet, and only the formatting remains).

So, it would really be ideal to copy all the hidden columns and not the hidden rows, and since the whole point of the button is to keep things extremely simple, I'd rather not have to unhide two columns every time I want to push it. If it's too complicated, I won't worry about it, though. The alternative is I could just reformat the layout of the inventory sheet to accomodate for the lack of hidden columns, but I don't think I'll be able to get it to look as clean.

I guess something like this?

Please Login or Register  to view this content.

Wow. That definitely seemed to work. Now, I'm going to have to dig through it and try to understand why. Thanks!