I'm working on some reports at work and am hoping that there is an easier solution to my problem than the one that I've found.
I am using an Excel workbook with 12 worksheets (tabs) - I have one tab for each month of the year. I have 11 graphs on each tab. In order to speed up my production time, I created the graphs (and data layout-which are all links to separate spreadsheets) for my "January" tab and worked with it until I had what I wanted. I then copy the completed tab and paste it to all of the other tabs. It is easy enough for me to do a "find and replace" to change the reference codes for the cells with links, but here is what I'm having a problem with: All of the graphs on every tab refer to my "January" tab. The find and replace won't make them refer to the proper tab. I can change the tab reference by clicking on the graph, selecting Source Data from the drop-down menu, and manually changing the tab reference for each data range. Thus my question - is there an easier way to copy a bunch of data and graphs from tab a paste them in tab b and have the graphs in tab b look to tab b for their values instead of tab a? OR - Am I just going to have to manually change this in every graph on every bleeping tab?
Google hasn't been kind in my search for this - many thanks for any suggestions.