I created excel file called "Dashborad" with only one sheet "Day 1"
This sheet contains alot of charts with data coming from another excel file called "Data" and from the sheet "D1"
What i need to do is to copy the Day1 sheet "with the sharts" to other sheets within the same file but each sheet should read from different sheest in "Data" file.
To make is simple
"Dashborad"- day 1 should read from "Data"-D1
"Dashborad"- day 2 should read from "Data"-D2
and so on
is there any way to update the links automatically instead of passing on each chart and adjust the data source manually,