Group and Outline

  • Hi all!

    I have created a macro that results in a Grouped list. Now, I would like to copy and paste the 'headers' of each group without the 'detail' into another spreadsheet.

    Everytime I select, copy the whole list it also pastes the 'detail' under each 'header'.. . Any help would be muchly appreciated?

    Any help would be muchly appreciated.. Cheers,


    Ps. Nice new forum btw!!

  • Re: Group and Outline

    Instead of vb code, one can use the following way

    Select the entire rows, press F5(or Ctrl+G or ) and then special and then select visible cells only and then the ususal copy and paste. Instead Alt+; will help to select the visible cells alone.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!