Make a special report with Excel

Closed
Mercedes - Feb 19, 2010 at 01:54 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 19, 2010 at 02:36 PM
Hello,
I have a worksheet in Excell and I would like to have different views/reports using the same data that I have in the first worksheet. I would like to instantly be able to combine some columns and view the data in a more reading way. I was thinking about creating a separate worksheet that would copy the columns needed but I do not know how to do that automatically. Do I need a macro? Please, help.
Thank youhttps://ccm.net/forum/office-software-25

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 19, 2010 at 02:36 PM
Yes you can do all that via macro. Ideally i would suggest that you add your own menu along with regular ones and have options to run report A, B .. You get the idea
0