Populating items from given value

Hi,

There are two groups of data:

Group1:

Please Login or Register  to view this content.

Group2:

Please Login or Register  to view this content.

Where the value of H1 is 4 which changes from time to time.

The desired solution is to populate the above groups according to the value at H1.

As there is 4 at H1 on this occasion the values of Group 1 and Group 2 should be newly populated only until 4th row & the values at other rows should be zero, For example:

NEW Group 1:

Please Login or Register  to view this content.

NEW Group 2:

Please Login or Register  to view this content.

For the convenience of respective contributors an workbook with datas is also provided to ease the explanation.
Thank you

"As there is 4 at H1 on this occasion the values of Group 1 and Group 2 should be newly populated only until 4th column & the values at other columns should be zero, For example:"

ROWS not columns, columns go up and down like the architectural column of a building, rows go horizontally.
You#'re filling in data up to the 4th ROW not 4th column, the 4th column is column D.

Cells can contain a formula or a number, not both.
You have numbers in row 5 onwards. If they have been set by a formula you just need to adjust the formula. IF(AND(ROW(A5)>H1,H1<>0),0,get number from somewhere)
But if they are manually typed in, not based on a formula, then the only way to do this is via VBA, of which I'm not an expert.

With helper column you can do. Insert in "A" column with =row() formula copy down.
In "J1"

Formula:

Please Login or Register  to view this content.

copy paste across.
See attach file.