Tigerexcel
Active Member
- Joined
- Mar 6, 2020
- Messages
- 493
- Office Version
- 365
- 2019
- Platform
- Windows
I would like to find some way of quickly generating a small list containing 2 to 3 columns, something like:
I'm expecting the solution to be a UDF or Macro as I can't think of a way of using a function which will remember the names mentioned. Ideally I'd like to pick a range eg 10 rows and have the procedure automatically populate the rows.
Cell Formulas | ||
---|---|---|
Range | Formula | |
C3:C12 | C3 | =RANDBETWEEN(20,50) |
I'm expecting the solution to be a UDF or Macro as I can't think of a way of using a function which will remember the names mentioned. Ideally I'd like to pick a range eg 10 rows and have the procedure automatically populate the rows.