anyone can do a micro for me please?
a1 has 1 number and it changes manully by me.
say a1 is 7,
what i want is when i click the button(with micro), b1-b30 will fill with random numbers between 1-11, but the number in any of this column can't be same as a1.
so, b1-b30 will have number between 1-11, but no 7 inside.
when i change a1 to 9, no 9 shows in b1-b30.
Bookmarks