I have 2 workbooks, A.xlsm and B.xlsm
Workbook A contains measurement data from an object.
Workbook B is identical to workbook A, but with measurement data from another object.
In workbook A I made a lot of graphs from these data.
Is it possible to copy the graphs from workbook A to workbook B so the graphs take the data from workbook B.
I tried all ways of copy / paste special, but I always had to change the workbook where the graph had to get its data.
A and B are two identical workbooks for 2 different objects.
If I have to do this manually, it is a lot of work. Workbook A contains 50 graphs and each graph containe 20 bars.
Workbook A contains measurement data from an object.
Workbook B is identical to workbook A, but with measurement data from another object.
In workbook A I made a lot of graphs from these data.
Is it possible to copy the graphs from workbook A to workbook B so the graphs take the data from workbook B.
I tried all ways of copy / paste special, but I always had to change the workbook where the graph had to get its data.
A and B are two identical workbooks for 2 different objects.
If I have to do this manually, it is a lot of work. Workbook A contains 50 graphs and each graph containe 20 bars.