Generate Random code for sampling for Different operator

[mazan2010]

Dear VBA Expert
I would like to know if someone have any idea how can create Random Code for 15 Operator
operator name will be in column A
Code will be generate in column B
the code consist of Alphabetical, but the code not repeated in the same day
please note that every day each operator will take two time sample meaning will generate two times for each one
hope my explanation is clear for all
regards

[adm.patrikbpl]

Please post sample excel file & what result u want.

[mazan2010]

i already create the file with formula to generate code and make also Cell for inquiry that give me responding name
the problem now when i enter any value in D2 automatic update for formula change value in Column B and when i make update manul
also not working
i think it will be better to create it by macro with buttom but i didnt know how can

[adm.patrikbpl]

U should use formula RAND() with round() & concatenate with alphabet in cell B2 .

Paste this in Cell C2 & paste down to last entry ...

PS : once u get all random codes then use paste special as value so later no change occur in provided codes...
[this requires no VB Code]:


=LEFT(B2,1)&ROUND(RAND()*100000,0)

Regards

[mazan2010]

if i paste it as value in the next time it not give me generation , i must enter the formula again

[mazan2010]

Dear all expert
now my idea is completed for what excatly i need hope every one can understand what i want
if Cell B1 is 200S divide number in column B4 to 150 because every BOX take 150 items for example in B4 contain 350
which divide by 150 which give 2.3 meaning generate three code in cell C4,D4 &E4
and ohter example B5 contain 250 which will generate only 2 code and leave third one empty
the same will be in other Column G and L
if the B1 contain 32S divide the number by 300 and create the same as above
if the cell B1 is 16S divide by 150 also

In Cell Q4 when i enter any code from Column H:O its give me responding name and shift number and box number
all this Macro will be connected to button as in attached file which will make two function
Stop randomize data generated and export it to new excel sheet with name from D1 (date)

i found the following code to stop randomize data generated but i need other as i explain above

[mazan2010]

hope someone can solve this for me

[mazan2010]

please can any one help me to make this

[mazan2010]

there is any one can help me to make action with macro
or even give me another idea for give every operator at every shift code random

[mazan2010]

Please can any one help me to finish this work