Track Weekly Trend

Hi!

Objective

• Track weekly trends.
• Table 1: updated with data for the current week.
• Table 2 (i.e. the 'historical table): dynamic, only contains data from the previous week.
• Compare values from the current week vs values from the previous week.

Context

• Table 1: update/overwrite data weekly
  • Data Source: Excel (file saved on SharePoint).
• Automate the below process.

Example of Required Output

Week 1

• Table 1: updated with new data.

Week 2

• Table 2 (i.e. the 'historical table') captures data as-is for Week 1 from Table 1.
• Table 1: updated with new data.

Week 3

• Table 2 (i.e. the 'historical table') overwrites Week 1 data with Week 2 data from Table 1.
• Table 1: updated with new data.

Week 4

• Table 2 (i.e. the 'historical table') overwrites Week 2 data with Week 3 data from Table 1
• Table 1: updated with new data.

The above is then repeated..

Any support is much appreciated!