Hi! Learning VBA just to create this table but my knowledge grows slowly so I ask for help
It is basically a draw. I'm using a XMatch function to generate random numbers and search a lookup array (in my example the numbers on the array are consecutive but that might no be the case always, that's why I have "redundant" numbers on VBA). When drawing for each cell (green ones are just examples), the code should compare the XMatch result with all cells on the rows above it AND to some cells on the columns on the left (on this example I used 10, but that number should be easily changeable).
The only known values are rows 30 and 31 that are copied from rows 32 and 33 from the column on the left, every other value should be drawn based on this criteria.
If this is successful, I will learn how that implementation is done and create a few more conditions to accept the XMatch (say, lines 23-26 should be drawn from a specific subset of cards, etc)
Thanks
Bookmarks