Using coding to autofill
 

Hi all

I have data sheets i want to automate.

Iwould like to be able to query the user for input and then fill the sheets
with common information.

Here goes:

In columns i want to be able to automate having the user enter the number 1,
20 times in 20 consecutive rows, then 2, 20 times, and so on to a user
defined amount of entries. For example(1) , if the user answers the question
"how many surveys" with 20 the above autofill continues until they have 20
enetred in 20 rows.

In a similar fashion i would like to be able to query for a date at the same
time and enter it in all of the rows. For example the user enters
Sepetmebr13, 2008 it autofills all the rows to the left of the above
example(1) with the same date.

Using coding to autofill*Multiposting*
 

Please don't multi-post. You have replies to the post you made yesterday.

Canada Lenny wrote:

Hi all

I have data sheets i want to automate.

Iwould like to be able to query the user for input and then fill the sheets
with common information.

Here goes:

In columns i want to be able to automate having the user enter the number 1,
20 times in 20 consecutive rows, then 2, 20 times, and so on to a user
defined amount of entries. For example(1) , if the user answers the question
"how many surveys" with 20 the above autofill continues until they have 20
enetred in 20 rows.

In a similar fashion i would like to be able to query for a date at the same
time and enter it in all of the rows. For example the user enters
Sepetmebr13, 2008 it autofills all the rows to the left of the above
example(1) with the same date.