I'm looking for a very simple Macro that when a number between 1-10 is presented, it automatically takes the current year and adds +1 to it automatically adds (not populates) that number of columns so as to provide an area for input. Sample attached. In the sample, the number 5 represents the number of years for "analysis". By putting in "5" the model needs to expand by copy and input of 6 additional rows, in 5 columns titled "2012", "2013", etc. The reason for the copy/insert is so formulas that are in the column before the date, and date expansion will be copied into the new columns.