Excel Macro for Linear Series Fill -

I have a set of data in Excel, population in millions of years, although I have to fill it in to fill the data. See examples below

  year - 2013-2014-2015-2016-2017--2018--2019--2020 male - 5-- -7 ------- 8 - -10FAM-4-- -5 --- -7 --- 9  

I know that I fill / series / linear, but I have been able to get hundreds of countries from 2000-2050 Need to do this I tried to record a macro to do it, but the phase value seems to be hard coded.

Is it possible or do I continue cutting and manually bullet?

Thank you

  Fill theGaps () "Fill the gaps starting from AA 2" The first difference on that line selection Find out. End (xltorite). Select 'and select the next non-blank range (selection, selection. End (xlToRight)). Choose. Data series Rowcol: = xlRows, Type: = xlLinear, Date: = xlDay, Step _: = 11845, Trend: = False selection. End (xlToLeft). 'Select' at the bottom line ActiveCell.Offset (1). Select the selection. End (xlToRight). 'Select and select the next non-blank range (selection, selection. End (xlToRight)). Select Selection Data series Rowcol: = xlRows, type: = xlLinear, date: = xlDay, step_: = 8598, trend: = incorrect selection. End (xlToLeft). Next line ActiveCell.Offset (1). Select the selection. End (xlToRight). 'Select and select the next non-blank range selection (Selection, Sel Action.nd (xltorit)). Data series roll: = XLRO, type: = XLLier, date: = XLDDA, step _: = 30400, go down in the next row of trend: = False 'activate offsets (1). Select end sub  

I think this should get you started. What I did was making a loop, and based on some explanation, calculates something to get the phase value, because it is actually only "variable"; there is a practice in Excel; I create a variable rng to represent the range of each row / data, and then use the appropriate methods to define that range instead of depending on the manual user selection of the range. Range = Range ("A2", Range ("A2"), Long-Range Dimension Value as a Range Range in the <.>