I have two worksheets in a workbook. Worksheet 1 is a data tabulation worksheet and at the end of each month is filled with data values and date as shown below. Worksheet 1 will always continue to fill in to the right with each new month and data value. Worksheet 2 has a table with 12 columns as I need this table to be a 12 month rolling period from the current month to the past 11 months. What I would like the table to do is look at the data in Worksheet 1 and then populate the table on Worksheet 2 such that the table contains only the data from Worksheet 1 Columns from the current month plus the past 11 months. For instance when the file runs on March 1, 2018 the table on Worksheet 2 would examine Worksheet 1 and be filled in with the vales from February 2018 to March 2017.
I'm not quite sure if this requires a macro or just some functions, but any help/guidance/ideas/suggestions would be appreciated.
Worksheet 1:
<tbody>
</tbody>
Worksheet 2:
<tbody>
</tbody>
I'm not quite sure if this requires a macro or just some functions, but any help/guidance/ideas/suggestions would be appreciated.
Worksheet 1:
1/31/2018 | 2/28/2018 | etc... |
19 | 6 |
<tbody>
</tbody>
Worksheet 2:
3/17 | 4/17 | 5/17 | 6/17 | 7/17 | 8/17 | 9/17 | 10/17 | 11/17 | 12/17 | 1/18 | 2/18 |
19 | 6 |
<tbody>
</tbody>