I'm trying to streamline my inventory process.
I get 'widgets' in a box of 4 on a pallet of 96. Each widget has a unique serial number. There is a barcode on the box with the S/N of each item in the box. Same for the pallet.
I want to scan or type the first S/N in cell A1 (1),
the last S/N in cell A2 (96),
Cell A3 calculates the difference (96) and populates cell B1 starting at 1 (the value of A1) to 96 (the value of A2)
I should have 96 S/N's in column B Starting at 1,2,3 - 96.
I need to do this multiple times and not overwrite any other cells.
I'm not locked in on which cells any of the data has to be in.