Hi All,
I have around 30 open sheets in the same workbook. I want to add the same chart in all work sheets (with the same formatting) that would be using the same cell ranges from the sheet its on. For example I want a chart that plots in Sheet 1 the ranges A1:100 from Sheet 1; in Sheet 2 the ranges A1:100 from Sheet 2 and so on. Is there an easy way to do that without having to copy the same sheet 30 times and manually edit?
Best, Boris
I have around 30 open sheets in the same workbook. I want to add the same chart in all work sheets (with the same formatting) that would be using the same cell ranges from the sheet its on. For example I want a chart that plots in Sheet 1 the ranges A1:100 from Sheet 1; in Sheet 2 the ranges A1:100 from Sheet 2 and so on. Is there an easy way to do that without having to copy the same sheet 30 times and manually edit?
Best, Boris
