Print a certain selection macro

I am developing this log of chemicals, and stuggaling for a place to start on a print macro, for all the newly chemicals created in "New Chemical" with columns a:k and from row 23 downwards based on number of entries.

Also i must be missing somethings obvious with two other macros that arent doing anything...

firstly a date input in first sheet "Chem Log" which with put the date in column K when column J is changed. Not sure if this is being affected by a macro that if Column J had "disposed" input then that row is moved to sheet 2 "Disposed".

And i have a similar move macro that is not working in the third sheet "New Chemical" to transfer the newly input chemicals to sheet one "Chem Log" not sure what to base this is on...

If anyone has any help or ideas it would be most apprechiated.

Thanks
Michael