Spreadsheet: 72629d1273328408-create-a-table-with-size-based-on-a-formula-vba-book1
Sheet: Sheet1

 |  | 0 | 0.4 | 0.8 | 1.2 | 1.6 | 2 | 2.4 |  |  |  |  |  | 1 | 0.2620156442173762
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 0.7856291125868695
 | 0.4 |  |  |  |  |  |  |  |  |  | [NAME] | 3.2 |  | 3 | 0.9651335109711447
 | 0.8 |  |  |  |  |  |  |  |  |  | [NAME] | 2.4 |  | 4 | 0.8091857987162694
 | 1.2 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 0.09422700336322598
 | 1.6 |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 0.7285045894028253
 | 2 |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 0.6720122645744411
 | 2.4 |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 0.8252740795424884
 | 2.8 |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 0.3712424876623388
 | 3.2 |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 0.4134742062701335
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | 0.9715644308055369
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 0.03961337187507175
 | I know of this method of organizing the data within excel, but I wanted a VBA version of this to automate things even further |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 0.2916722605919733
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 0.8168383435936364
 | I wanted this to work for any table I would like to create, that is, not only for (3,2 x 2,4) but for any size that i previously choose |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 0.4616258294735491
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | 0.05877227307829003
 | Of course I would have more data, not just 63 rows of data then. |  |  |  |  |  |  |  |  |  |  |  |  | 17 | 0.08147750143096477
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | 0.2977425549164785
 | Is this possible to do? |  |  |  |  |  |  |  |  |  |  |  |  | 19 | 0.8623097554324799
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 0.09748354658262226
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 | 0.08213213602878433
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 | 0.9990331665872079
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | 0.6607400280215829
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 | 0.1799484234308686
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 0.6943570639816024
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 | 0.663268447469405
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 27 | 0.4058795739814434
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 | 0.4205561501524129
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 | 0.3337700589550661
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 0.6665738897992175
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 | 0.6988051296408253
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 | 0.4558195668184568
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 33 | 0.2091611867086201
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 | 0.8885484120163891
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 | 0.3611092818679067
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 36 | 0.948392235992807
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 37 | 0.332069504512341
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 38 | 0.2044283058112759
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 39 | 0.06191417193800675
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 | 0.775107578203267
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 41 | 0.6638181810534534
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 42 | 0.137094615331641
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 43 | 0.321154470347019
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 44 | 0.3178884216526212
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 45 | 0.865183628284278
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 46 | 0.4448266242837224
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 47 | 0.4682672427536927
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 48 | 0.01706658028361474
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 49 | 0.7254564167166553
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 0.8526792073828551
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 51 | 0.03899820502982454
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 52 | 0.6098295331820351
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 53 | 0.8825570237646216
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 54 | 0.6047830296376162
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 55 | 0.1604962709330326
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 56 | 0.7916859715128794
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 57 | 0.6444548592287778
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 58 | 0.9665232601565079
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 59 | 0.8349775265160373
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 60 | 0.6943402047688909
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 61 | 0.3650299485143211
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 62 | 0.06588398650750005
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 63 | 0.6151524388927045