anne.gomes
05-28-2014, 03:49 PM
Hi Everyone,
Ive got a pretty challenging task to do which I can't really seem to find any info off on the net.
So I've got one excel workbook that has 4 different worksheets all with 1 different pivot graph each. These worksheets are called: "Sheet1", "Sheet2", "Sheet3", and "Sheet4". All these graphs have the same filter selections e.g. apples, bananas, pears, and oranges. So if in Sheet1 if I selected apples then I want apples to be selected in all the other 3 worksheets and have all four apple graphs to be copied and pasted automatically into a new worksheet.
Can this be done using vba? Can someone please help me?
thanks so much
Ive got a pretty challenging task to do which I can't really seem to find any info off on the net.
So I've got one excel workbook that has 4 different worksheets all with 1 different pivot graph each. These worksheets are called: "Sheet1", "Sheet2", "Sheet3", and "Sheet4". All these graphs have the same filter selections e.g. apples, bananas, pears, and oranges. So if in Sheet1 if I selected apples then I want apples to be selected in all the other 3 worksheets and have all four apple graphs to be copied and pasted automatically into a new worksheet.
Can this be done using vba? Can someone please help me?
thanks so much