Hi all.
I'm new to this. I'm needing to create 6 graphs (line) on numerous worksheets and all of my data comes from the same ranges in each. Every page is formatted identically. When I run a Macro, it uses the data from the page that I created the macro on and doesn't automatically pull the data from the sheet I run it on, like I'd like it to. Can anyone help??? What do I need to do in the macro so it uses the current sheet rather than the original?
Here's the macro I am running now (this would be what I used to create graphs for sheet 44035...but when I run the macro in 44039, it still uses 44035 data...:
I've attached the file. The data for the next set of graphs is on sheet 44037.
Bookmarks