Hi all
I hope you can help.
I have a sheet "Input" where i via VBA would like to copy data from B7:E26 and paste it in the next empty row (B:E) in the sheet "Skift".
I do not know if this has any relevance but a row in the input sheet will always be filled from B to E, but the amount of rows with content will vary from 1 (row 7) to 20 (row 26)
(I am scanning a barcode in cell C4, which then automatically fills out the B7:E26. I would then like to click on a button, transfer the content of B7:E26 to the "Skift" sheet and delete the content of B7:E26.)
Hope this makes sense.
Thak you in advance
I hope you can help.
I have a sheet "Input" where i via VBA would like to copy data from B7:E26 and paste it in the next empty row (B:E) in the sheet "Skift".
I do not know if this has any relevance but a row in the input sheet will always be filled from B to E, but the amount of rows with content will vary from 1 (row 7) to 20 (row 26)
(I am scanning a barcode in cell C4, which then automatically fills out the B7:E26. I would then like to click on a button, transfer the content of B7:E26 to the "Skift" sheet and delete the content of B7:E26.)
Hope this makes sense.
Thak you in advance