Managing data between worksheets

Originally Posted by Drickmt

Through my limited excel skills, I have been unable to figure out a solution to my problem.

I have a complex (cumbersome) employee schedule that is broken down by day (columns), employee (rows), and work assignment (data). It automatically displays overtime positions for work assignments that are not filled. I want to export the overtime (by day/column) to another worksheet for posting, however I don't want to include all the days there is no overtime (a 0 value).

In an attempt to simplify, if columns A, B, and C don't have any overtime, but columns D, E, F, and G do have overtime. How can I export just the columns with overtime to another worksheet?

I don't know if I'm further simplifying or further complicating, but there's some graphic examples of what I'm trying to accomplish.

Maybe attach a zipped workbook, it would be easier to work with it