I have a data entry form for generating bar codes that asks for a Sample ID for cell A1 and the number of samples to be labeled in C1.
I am having trouble writing a VBA script that will autofill the column from A2 down to Ax where x = number of samples entered into C1. The bar codes are generated in the adjacent B column.
Any help would be greatly appreciated.
I am having trouble writing a VBA script that will autofill the column from A2 down to Ax where x = number of samples entered into C1. The bar codes are generated in the adjacent B column.
Any help would be greatly appreciated.