randbetween to generate barcodes

Hi everyone,

I am trying to generate barcodes for my inventory. here is the case:
1. digits of barcodes are 6
2. lowest value is 100000, highest is 999999
3. there should be no duplicate between A1: A20,000 where the data will be in

any help will be appreciated. thanks and have a great day!