If I have a value in Cell A1, I would like the same "amount" of shapes to show on sheet in the columns to the right of it.

Example: A1 = 4
B1 would have an Oval in it.
C1 would have an Oval in it.
D1 would have an Oval in it.
E1 would have an Oval in it.

Each time I changed the value in A1 it would give me that amount of shapes. I would like to do this for about 50 rows in Column A.

If you know the answer or could send me to a tutorial, that would be awesome.