looping help

Hi,

I have one cell which i would like to loop.

In cell B2 I have a number - this could be from 1 to 100

In cell a1 i would like a loop so that the number changes from 1 - 10

The number in cell B2 determines how many times the loop occurs.

so for example.

cell b2 is 3

Cell a1 goes through the numbers 1 - 10 (3 times)


I look forward to hearing from anyone.

Many Thanks TM