VBA code to select certain columns to use in formula

[Alpacino]

Hi,
Is it possible to develop a code that only selects certain columns.
E.g. I have a table full of different Kpi in each row
Sales
Waste
Payroll
Going along the columns is wk numbers and I have set up a Formulas to find out Year to date figures in column E.
I want to break down the figures into periods (periods consisting of 5 weeks or 4 weeks) so I can find out how much each Kpi was for each period.
Is there a VBA code to use only weeks in a selected period (using data validation in cell D5

 

[Weaver]

The beauty of vba code is that there doesn't have to be one - you can write it.

Thinking about it, if your week no. columns have the week ending date in them as well, you might be able to use a formula. Difficult to say without some idea of what the data looks like tho.