How to copy a number of sheets into one?

A

Adam Tyskiewicz

Hi all!

I have a simple problem but my knowledge of VBA is very week so I'm asking
you.

I have and Excel file with 60 sheet in it. I'd like to export all the data
from all the sheets into one CSV file. If only I knew how to write a macro
which creates a new sheet and copies and pastes the contents of all the
other sheets into it, one uder another... Do you have any idea?
 
Top