Dear all,

I apologize if this question has been addressed before but I am having difficulty finding a time-efficient process for a task I am doing. I have a workbook containing many (380!!) worksheets. Each worksheet represents a cross-section of the river in which I am developing a hydrologic model. I am trying to draw a XY line graph for each worksheet (cross-section) using the river's computed flow data (column L4:L22) on the X-axis with the river's depth data (column D4:D22) as the Y-axis. Each worksheet is set up identically, i.e. the X-axis (flow) data are always L4:L22 & the Y-axis (depth) data are always D4:D22.

graph2.JPG

This is a screenshot of what a typical worksheet looks like, with the X data highlighted in yellow and the Y data highlighted in green.

I've created a simply XY line graph to represent the data on this worksheet, shown here:

graph.JPG

I want to create a similar graph for each of the 380 worksheets I have without having to manually select the data on each worksheet.

I've recorded a macros for copying and pasting a finished graph from a preceding worksheet to the next but when I run the macros it returns a graph with the source data from the original worksheet and fails to update the source data for the newer worksheet I am attempting to graph.

Any help on this matter would be greatly appreciated!

best,

Adam