Auto Populate Fields

[rminns]

This relates to a thread I started in Excel Worksheet Functions group:

http://www.excelforum.com/showthread.php?t=642149

I need a script that will copy the previous data down to the next row, depending on what the number entered is.

i.e. cell A1 = Dell, B1 = Laptop, C1 = D610, and then D1 = 8 - I need a function that will then copy the information from A1, B1 and C1 down so that I have 8 rows with the same information in (that is the 1 row that I manually entered and then 7 rows with copied data).

In the previous thread we used a formula which worked fine, if the data entered was unique. However the probability is that a user will enter more than one type of data - i.e. the example above would need 8 rows of Dell, Laptop, D610 but the user may then need to enter 10 rows of something completely different in which case the formula breaks down.

Any help would be great - and thanks for NBVC for answers in the previous thread!

[BigBas]

Try using this code:

Please Login or Register  to view this content.

When you enter a quantity in the quantity column, it will automatically fill down the number in the quantity. Try it out with differing numbers, and report back if you have any questions.

EDIT: I had a code error that I corrected.

[martindwilson]

or try

Please Login or Register  to view this content.

all you have to do is always enter what you want in a1 b1 c1 and number of times in d1 run macro 'martin' (i'd put it on a button labled ''add items" or similar
then this will copy those rows to next free rows that numer of times