Macro to be applied in different column range

[execaps]

Hi! Greetings to all.

Can someone please help me complete my Drawing logbook file with macro and conditional formatting.

For information, I applied some macro formulas in my file (attached for verification). In Tab KARW-A, I intend to automatized the input of dates as per the movement of my drawings for specified range L6:V249 by using macro. Since drawings are not 100% all will be approved, revisions will come. Then, my problem also comes out... I don't know how to add/end a macro that will repeat the same thing it's doing for range X6:AH249, and so on.

Thank you in advance.