PDA

View Full Version : VBasic in Excel 97



14-12-2001, 12:37 PM
I have two pivot tables on different pages on a spreadsheet, and I would like to update their PageValues simultaneously, probably through a VBasic macro. I have tried pasting the value from one to the other and failed. Is there a way to do this?

Cheers,

Steve

14-12-2001, 03:15 PM
Edit, Copy;
Edit, Paste Special?