Hi there everyone!


how can I copy a work sheet that is a result of a formulated work sheet (within the same file) to another work book?

I tried using the ordinary copy and paste and all I got is #REF!. and If I try the paste special (values)I got the dialogue box that says: "This operation requires the merged cells to be identically sized".

To give you an overview on what am doing so far.
1. I collect daily attendance from different areas that consist of executive, mid_manager and regular. Each file has a multiple sheets with a corresponding initial reports (i.e. executive; mid_manager; and regular).
2. Then I consolidate all the initial reports to another file as my final report.

Number 2 is my question, is this doable, even in non-VB?