Hello, I need your help. I have to create a graph that will take data from another Excel file, but these data must be consistent with existing Excel.

For example:

ExcelNo.1 has the following data:



Week 17 50
Week 18 60
Week 19 40
Goal 50

ExcelNo.2 data:

Goal 50
Week 17 50
Week 18 60
Week 19 40
Week 20 40
Week 21 40 and so on

Is it possible to change your data from week 17 to week 18, depending on the current week.

Example:

Week 18 60
Week 19 40
Week 20 50
Goal 50