Been a long time since I have had to ask for help on here, but I have always had my problem solved here. I'm working on a project that is almost done except for one thing I would like to be able to do.
Here is the task
I will have a grid of cells 10X12 that is 120 cells total b37 thru n46
above this grid i will have 4 cells with data entered . In the cells beside the data i will
enter the percentage of boxes or cells i want this particular data to fill ( I show this at bottom). So say for
TRI i want to fill 10% of the grid cells so i would like for the code to fill 12 cells with TRI. TRT i want to fill 20% so i need to fill 24 cells with TRT. This goes on until all cells in the grid get filled or populated. this data can go into the cells anyway that makes it easiest. I am going to randomize the data once i have all boxes in the grid populated. Thanks for any help that anyone might offer.
TRI 10%
TRT 20%
BRI 25%
BRT 45%
Bookmarks