-1

I would like to have people enter a number 1 through 20 into an excel field and then based on that number I would automatically create an enter in each row of a specific column.

So if I had a field and I put the number 10 in it. Then it would fill 10 fields of a column with the text:

Company 1
Company 2
Company 3

and so on.

Any thoughts on how to do this? I can't even think of where to begin.

Thanks,

Gary's Student
  • 94,018
  • 8
  • 54
  • 89
Phi
  • 231
  • 9
  • 21
  • I think you'd need a userform for user input for this, how would the code know which row and which column? – Sgdva Jun 03 '16 at 20:52
  • 2
    Rule of thumb, if your question includes "I can't even think of where to begin", it's most likely too broad for Stack Overflow. Please read [ask] for more info. – Mathieu Guindon Jun 03 '16 at 21:11
  • I agree with @Sgdva. Userform will be the way to go. See [here](http://www.excel-easy.com/vba/userform.html) how to use Userforms in VBA. – VBA Pete Jun 03 '16 at 21:27

1 Answers1

1

You might try searching here on Stack...

Here is a potential link that might be helpful about firing a macro upon a cell change. You can then create a macro that will fill in x columns.

Community
  • 1
  • 1
David D
  • 46
  • 5