So the below code gets a certain period from an InputBox and posts values for each period in a spreadsheet. What I'm struggling with is applying a multipler for each year. The number of periods is typically not a full year, it's usually a partial year.
For iCol = 0 To nPeriods...