Dear Excel community,
Suppose I have a spreadsheet containing data looking like this table below,
5/10/2017
Column B Column C Column D
Oct-17
Nov-17
Dec-17 1 1
Jan-18
Feb-18
Mar-18 2 2
Apr-18
May-18
Jun-18 3 3
Jul-18
Aug-18
Sep-18 4 4
Oct-18
Nov-18
Dec-18 5 5
Jan-19
Feb-19
Mar-19 6 6
Apr-19
May-19
Jun-19 7 7
Jul-19
Aug-19
Sep-19 8 8
Oct-19
Nov-19
Dec-19 9 9
What macro should I implement so that I can keep a daily archive of these numbers on another page to look like this format below.
1 2 3 4 5 6 7 8 9
date
date 2
I will do this for data on column C above and then repeat the same for Column D so it will be 2 archives of the respective data for each column.
Your great help is much appreciated!!
Suppose I have a spreadsheet containing data looking like this table below,
5/10/2017
Column B Column C Column D
Oct-17
Nov-17
Dec-17 1 1
Jan-18
Feb-18
Mar-18 2 2
Apr-18
May-18
Jun-18 3 3
Jul-18
Aug-18
Sep-18 4 4
Oct-18
Nov-18
Dec-18 5 5
Jan-19
Feb-19
Mar-19 6 6
Apr-19
May-19
Jun-19 7 7
Jul-19
Aug-19
Sep-19 8 8
Oct-19
Nov-19
Dec-19 9 9
What macro should I implement so that I can keep a daily archive of these numbers on another page to look like this format below.
1 2 3 4 5 6 7 8 9
date
date 2
I will do this for data on column C above and then repeat the same for Column D so it will be 2 archives of the respective data for each column.
Your great help is much appreciated!!