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.
My daughter is an art/graphic design major and just got her brand new Macbook Pro, and is in the process of getting all the required software for school (Office, iWork, Adobe Cloud, etc...) Never having had a Mac before, my question is: