Hi,
This has got to be a simple solution.
I'm needing to add a serial number suffix that is based on a quantity.
If I have a prefix in B1 and my QTY in B2, I need to automatically generate serial number suffix, i.e -001 through a max of 1000 in column D.
Is there an easy way to do this? I would like to just be able to put the job specific data in one area and have excel do the rest.
Thanks!
This has got to be a simple solution.
I'm needing to add a serial number suffix that is based on a quantity.
If I have a prefix in B1 and my QTY in B2, I need to automatically generate serial number suffix, i.e -001 through a max of 1000 in column D.
Is there an easy way to do this? I would like to just be able to put the job specific data in one area and have excel do the rest.
Thanks!