Hello,

Basically, I have 2 sheets to concentrate on. On the initial sheet (Sheet 1), I want the values in B2:P2 rows (for the entire sheet) to be copied over to a sheet titled PRINT. IF, The value in column L on Sheet 1 is less than 1. When they are copied I need it to be the equivalent of Paste Values so no formatting is carried over.


So more quickly, Sheet 1, B:P rows should be copied to PRINT, IF L:L is less than 1 on Sheet 1.

Thanks,