add string in random cells of column for each same id

[fatoom91]

Hi I'm trying to add string = "bid canceled" in a column in range 2 to 6 time for each same Auction-ID if the bid status is empty:

Please Login or Register  to view this content.

the attachment in sheet one is the output that I except, I didnt know how to insert string 2 times or 3 or 4 ...6 times in random cells for each auction id if the cells are empty,any idea for that?

[WideBoyDixon]

Give this a try:

Please Login or Register  to view this content.

WBD

[Richard Buttrey]

Your upload was a .xlsx file and therefore didn't contain the macro. Please upload the .xlsm file

In addition please indicate in a narrative form exactly what you want to do, the rules you apply and for a few of your results explain how you arrived at them.

It seems there's an element of randomness in your system, but rather than reverse engineer your macro, which presumably isn't giving the results you want since you've raised the problem here, I'd rather know the overall aim.

[fatoom91]

Give this a try:

Please Login or Register  to view this content.

WBD

thanks so much