Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sum by coding without 0 | New Users to Excel | |||
sum by coding | New Users to Excel | |||
How to fix the coding? | Excel Worksheet Functions | |||
Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) | |||
coding | Excel Discussion (Misc queries) |