VBA Help for repetitive task pls help

Looking for a solution to my IF statements to be reduced as i have some as long as 72 columns long and for each i have to write another IF statement to copy the data then print that data. It works but its time consuming to write it all. Can anyone help me. Here is my breakdown of some of the stuff i have written;

Please Login or Register  to view this content.

Hi kjhawks and welcome to the forum,

First edit your post above and select all those code lines and click on the "#" icon above. It will make your post look like mine below. Here is a hint on cleaning up one section...

Please Login or Register  to view this content.