G
gaga.kaplan
Would anyone know what type of code to use so that it copies 1981q1
into Jan 1981, Feb 1981, Apr 1981 and then moves on to 1981q2 and
copies the value there to paste it into Apr 1981, May 1981, and Jun
1981....
This goes on till 2050 and it is a pain to continue doing this.
column A are the numbers 111, 222, 333....
Column B are the months-year
Column C are the numbers that are copied from Column F
Column D is blank
Column E are the years and quarters
Column F is the GDP in that quarter.
1 Jan-1981 5,307.5 1981q1 5,307.5
1 Feb-1981 5,307.5 1981q2 5,266.1
1 Mar-1981 5,307.5 1981q3 5,329.8
2 Apr-1981 5,266.1 1981q4 5,263.4
2 May-1981 5,266.1 1982q1 5,177.1
2 Jun-1981 5,266.1 1982q2 5,204.9
3 Jul-1981 1982q3 5,185.2
3 Aug-1981 1982q4 5,189.8
3 Sep-1981 1983q1 5,253.8
4 Oct-1981 1983q2 5,372.3
4 Nov-1981 1983q3 5,478.4
4 Dec-1981 1983q4 5,590.5
5 Jan-1982 1984q1 5,699.8
5 Feb-1982 1984q2 5,797.9
5 Mar-1982 1984q3 5,854.3
6 Apr-1982 1984q4 5,902.4
into Jan 1981, Feb 1981, Apr 1981 and then moves on to 1981q2 and
copies the value there to paste it into Apr 1981, May 1981, and Jun
1981....
This goes on till 2050 and it is a pain to continue doing this.
column A are the numbers 111, 222, 333....
Column B are the months-year
Column C are the numbers that are copied from Column F
Column D is blank
Column E are the years and quarters
Column F is the GDP in that quarter.
1 Jan-1981 5,307.5 1981q1 5,307.5
1 Feb-1981 5,307.5 1981q2 5,266.1
1 Mar-1981 5,307.5 1981q3 5,329.8
2 Apr-1981 5,266.1 1981q4 5,263.4
2 May-1981 5,266.1 1982q1 5,177.1
2 Jun-1981 5,266.1 1982q2 5,204.9
3 Jul-1981 1982q3 5,185.2
3 Aug-1981 1982q4 5,189.8
3 Sep-1981 1983q1 5,253.8
4 Oct-1981 1983q2 5,372.3
4 Nov-1981 1983q3 5,478.4
4 Dec-1981 1983q4 5,590.5
5 Jan-1982 1984q1 5,699.8
5 Feb-1982 1984q2 5,797.9
5 Mar-1982 1984q3 5,854.3
6 Apr-1982 1984q4 5,902.4