Hi:
I have create a macro to copy the contents of one sheet to another. My intention is to maintain all the formats, including the grouping. I have achieved most of what I want, with the exception of the groups/outlines. When I copy over, all the information is gone. Any help is much appreciated.
I have included a sample sheet as an example. Press the button on the "Command" sheet will active that marco, which suppose to copy contents from the "Original" sheet to the"Output" sheet.
Thanks in advance.
Norman
Bookmarks