Grouping columns depending on a row's values

[Flavinho]

Hello, please your help with a code for the following:

Grouping the range of columns which values in a row is greater than x number, for example:

Row 3 of a spreadsheet contains the number of the period:C3=1, D3=2, E3=3, F3=4, G3=5, H3=6...Q3=15

Cell A1 contains the number of periods to report. Let's assume that we want to report the first 5 periods, so A1=5

Now, assuming the above, the required code should group and hide columns H to Q.

Thanks in advance for your help!

[WasWodge]

Possibly

Please Login or Register  to view this content.

or even

Please Login or Register  to view this content.

[Flavinho]

Thank you very much WasWodge. Really appreciated. I'll go with alternative #1.