I would like vba code that will randomly select 15% of items, is it possible ?
So In column E are the 'Type' so there are Apples 17 Leeks 14 etc.
In column N I want to put the word 'check' against 15% of each 'Type.
So for Apples I would select 3, for Leek I would select 2 etc.
Of course the names would change all the time so I am thinking that it should be based on say the first 4 letters in each cell in column E, so like Appl, Leek, Oran etc etc.
I have attached a file to [hopefully] show it more clearly.