Hi, so I'm working on a grant project that I really hope you guys can help me with. I have three or four graphs that I have to duplicate about 800 times. I would like to be able to have just one kind of template book to work from and copy and paste the graphs into there. The problem is when I do this I have to go in and manually change the workbook reference to the one that the graph is actually in. With three graphs having three series in each it is extremely time consuming.


2. Might be getting a little out there but they all have different numbers of rows so if it could automatically change the range would be great as well.

3. The charts also all have titles so I'm looking for a fast way to update those too.

Thanks guys, really appreciate it. The Montana and North Dakota economy will appreciate it as well.