I am barcoding items. As I click the scanner gun, the item goes in to Sheet 1, Column A. Like a1,a2, a3 etc.
I do the mid function to separate the barcode values into columns on Sheet2.. Like A1 ITEM, B1 Description, C1 Price.
What I need is to be able to insert a new row in sheet 2 when its scanned.
copy the formulas down from the previous row and paste. Item Description Price
Like code is Sheet 1 1000Red Tshirt-L $10.00..... Sheet 2..... 1000 T shirt-L $10.00
I already have the macro to find last cell and put in the totals.
I do the mid function to separate the barcode values into columns on Sheet2.. Like A1 ITEM, B1 Description, C1 Price.
What I need is to be able to insert a new row in sheet 2 when its scanned.
copy the formulas down from the previous row and paste. Item Description Price
Like code is Sheet 1 1000Red Tshirt-L $10.00..... Sheet 2..... 1000 T shirt-L $10.00
I already have the macro to find last cell and put in the totals.