I have 40 groups. I need to enter a four digit number for each.
There are 12 numbers, so many groups will be duplicate numbers.
Is there any way I can enter a number or letter and have the
4 digit number substituted into my sheet?
Like this
a=2323
b=4356
c=4653
Then the number will appear on the sheet.
Thanks for any assistance
Skip