2021-07-30

Loop through range over cells after each cell is copied print a sheet

I have made a sheet so someone can record some references for a pallet and a product code. I would the like them to be able to print this as a label I've made on another sheet when they have finished inputting all the data.

I need some code that allow me too loop through a range ("B5:last row") on sheet ("In (New)") and every time it finds a Ref it will copy the values from B(whatever) and the C value next to it and paste it on my label Sheet ("label") in the range ("K17:L17") then print the label out of the default printer.



from Recent Questions - Stack Overflow https://ift.tt/377rRHt
https://ift.tt/eA8V8J

No comments:

Post a Comment