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...