How to make VBA offset and speed up coding

Dear Excel Gods,



I've pieced together this code from information I have found online and the code works perfectly right now. I originally wanted to make this a user form where it would simply add the values to the next free column but that may be out of my league.

To help get this project over with I'd like to make this code work for multiple columns with out copying and pasting the code. I think this would be called doing "offset"?

Right now it works for P1 down.

If D1 = True, then do the code below for columns D:E
If F1 = True, then do the code below for columns F:G
If H1 = True, then do the code below for columns H:I
If J1 = True, then do the code below for columns J:K
ect

I'm VERY new to VBA so please be detailed in your response.


Thank you!

Please Login or Register  to view this content.

It is the same code however some of the formulas need to offset as well

P:Q Column would be

Please Login or Register  to view this content.

R:S Column would be

Please Login or Register  to view this content.

I'm 99% that's correct,

I may be over looking one formula but for the most part that is the idea

I've attached the file, very new to VBA's so I just want to make sure I'm being clear

Price Template2.xlsm