Copy, Paste, Print data to a form & repeat process on next row.

[Bikeman]

Hello, looking for some help. I have a spreadsheet with the first sheet called “LOG” that an employee fills out daily with many rows of data and then needs to print form to ship with product. I’m trying to see if there is a way when the employee get to column D and enters the serial number a formula would copy A2 (Date), B2 (Signature) and D2 (Serial Number) to a second sheet called “FORM” into cells C12 (Date), D14 (Serial Number) and E31 (Signature) and print the form. Would like this to happen each time a row is filled out because a copy of the form with each serial number, date & signature needs to be printed and attached to a tool before it ships.
Not sure a formula is the best way to go about this, I tried a Macro that works to copy, paste and print but can’t figure out how to move down to the next row and repeat the process.

Please see attached (TJ12 Assembly Test Log.xlsm)

Thanks for any help it is greatly appreciated.
Bikeman

[LeoTaxi]

Please Login or Register  to view this content.

Kind regards
Leo

[Bikeman]

Leo,

Thank you for the code, this works perfect!

Bikeman