I have several tests for 23 students. Each student has a chartsheet in its own tab. Currently the student's name is in Column A and Columns B:F have the scores.
Now I have added a score in column G.
How can I update the Columns.
The Chart Data Range shows the following for one of the students. Details is the name of the tab that is being charted.
=Details!$B$6:$F$6,Details!$B$18:$F$18
I want to change the range from F to G in all chartsheets.
Can someone please help me with a macro that would do this?
Thank you.
Bookmarks