Hello,

I have a report which uses a lot of pivot tables which makes for a large file size. The Report generation is automated, so what I need is a macro that will start on the first sheet of the work book, copy, then paste values, then move onto the next worksheet and do the same until it has completed all worksheets.
Is it possible for this to be done without knowing the names of the worksheets, or the number of worksheets?

Thanks for any help