A quick question if I may. I really don't know if this is possible but I'll ask anyway.
Random numbers. I need Excel to generate a random number consisting of 4-5 digits. Numbers or letter. Doesn't matter. Preferably a mixture of both but I could settle for numbers only.
For example. '234961' is for Carpentry Works on Site A. I'll use this number as a Work Order when I send out the work. So when I get invoiced at the end of the month I'd know that '234961' were for Carpentry Works on Site A. So a UI type system would be great but probably a bit too advanced for my burgeoning skills. I'd settle for Column A to be populated with 20k random numbers and just work off that. Makes sense?
Or perhaps another idea on how to better implement such a system?
Random numbers. I need Excel to generate a random number consisting of 4-5 digits. Numbers or letter. Doesn't matter. Preferably a mixture of both but I could settle for numbers only.
For example. '234961' is for Carpentry Works on Site A. I'll use this number as a Work Order when I send out the work. So when I get invoiced at the end of the month I'd know that '234961' were for Carpentry Works on Site A. So a UI type system would be great but probably a bit too advanced for my burgeoning skills. I'd settle for Column A to be populated with 20k random numbers and just work off that. Makes sense?
Or perhaps another idea on how to better implement such a system?