Hi all


i have a problem that i am unable to overcome with my knowlegde of EXCEL.

Here goes:

I want to automate some data entry.

I want to fill in the same column with the number 1 for 20 rows, then i want
to fill the next 20 rows in the same column with a 2 and so on.

The total amount of times i do that i want controlled by the user with an
input box. So say i ask the user how many surveys do they want entered. They
say 20.
I want incrementing numbers from 1 to 20 in blocks of 20 in the same column.

I also need the same thing for a name. The only different caveat is that the
name stays the same for all rows. Example, 20 surveys * 20 rows = 400 entries
all the same name. Same idea here. I would query the data entry person to
what name they want repeated 400 times.

If that all could be thrown into one macro i would be greatful. I have tried
for several days now and creating an autofill list from 20 *1 to 20*60 is my
temporary solution.

Cheers