Hide / Remove / Delete "Automatically" multiple columns

[treatsmarket]

i have a worksheet of all my sales of the last few years divided by the months,
every month have a few columns, example sep 09 have 4 columns "F" Qty, "G" Amount, "H" % of Sales, "I" Avg Price, and the next 4 columns are for oct...............

i want to see only the QTY of each month, how can i automatically hide / delete the other 3 columns of all months without highlighting each column separately

i'm not very good in formulas and i don't know macros at all ,

i have attached a sample of my file, please can you put the formula / macro in the file with a clear instruction

many thanks

[p24leclerc]

I tink the easiest way is to group your columns you want to hide. Here is how to do with the macro I wrote in the attached file. As long as you always have the same numbers of columns in each group.
Open the attached file. When you are in your worksheet, click on the VIEW menu and click on Macro(far right) and then on SEE MACRO. A list a available macro will show up and you have to click on the one you want to run. The one I wrote for you is named MACRO1. So click on this name and click on RUN. You'll see +s appear above the column's letters with 2 numbers ( 1 and 2) in small squares on the left of those +s.
If you click on the number 1, it will collapse all of the columns defined by the macro. If you click on the number 2, it will unhide all the columns. If you manually click on one of the + signs, it will unhide or expand the columns on its left and the + is transformed in -. If you click on the - sign, it will hide the columns on its left again.
Hope it is clear enough for you.
If not, get back with more questions here.