Macro for Archiving

afrobea_r

Board Regular
Joined
Aug 16, 2015
Messages
76
Dear Excel Community,

Suppose I have a table that looks like this, whereby column B contains the months, columns C & E contains specific values. Above Column B there will be a date function that captures the dates daily.

Column BColumn CColumnDColumn E
Oct-17
Nov-17
Dec-1711
Jan-18
Feb-18
Mar-1822
Apr-18
May-18
Jun-1833
Jul-18
Aug-18
Sep-1844
Oct-18
Nov-18
Dec-1855
Jan-19
Feb-19
Mar-1966
Apr-19
May-19
Jun-1977
Jul-19
Aug-19
Sep-1988
Oct-19
Nov-19
Dec-1999

<colgroup><col><col span="3"></colgroup><tbody>
</tbody>

What macro can I use to historically archive the data into this format at another worksheet:

123456789
date
date 2

<colgroup><col width="64" span="10" style="width:48pt"> </colgroup><tbody>
</tbody>

I will be archiving one set for data in column C and then for column E separately. Help needed! Thanks alot in advance!

Best Regards,
afrobea_r
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

afrobea_r

Board Regular
Joined
Aug 16, 2015
Messages
76
do you want Dec 17 below the 1, Mar 18 below the 2, etc

Hi oldbrewer,

Thanks for your reply. For the dates, it will be a time/date stamp as I plan to archive the figures on a daily basis. This is so I can have the historical numbers to run any analyses in the future. Hope that clarifies!
 

afrobea_r

Board Regular
Joined
Aug 16, 2015
Messages
76

ADVERTISEMENT

no, it doesn't - show us how it will look please.

Hi,

Below is an example of how it will be. Basically my intention is to curate a table of the daily prices. So if the 3rd day was 12/10/2017. I would archive it again and I now have a series.

123456789
10/10/2017
11/10/2017

<colgroup><col><col span="9"></colgroup><tbody>
</tbody>






<colgroup><col><col span="9"></colgroup><tbody>
</tbody>
 

oldbrewer

Well-known Member
Joined
Apr 11, 2010
Messages
11,004
but what goes in to the cell that is the intersection of 10/10/2017 and 1 ? eg where are the daily prices in your example ?
 

afrobea_r

Board Regular
Joined
Aug 16, 2015
Messages
76
but what goes in to the cell that is the intersection of 10/10/2017 and 1 ? eg where are the daily prices in your example ?

Hi,

Essentially the figures that goes into the intersection will be numerical values. The 1 to 9 is meant to indicate the 9 values that I will need on a daily basis. So if I were to include arbitrary figures...the collated table will look like this.

123456789
10/10/2017100050009000130001700021000250002900033000
11/10/201760001000014000180002200026000300003400038000

<colgroup><col><col span="9"></colgroup><tbody>
</tbody>
 

oldbrewer

Well-known Member
Joined
Apr 11, 2010
Messages
11,004
your original post has only months in it - now we have 9 values for each day. I must be having a bad week because I still do not understand what you want. Maybe you want the monthly total archived ?
 

Watch MrExcel Video

Forum statistics

Threads
1,132,685
Messages
5,654,745
Members
418,149
Latest member
amamiche67

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top