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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top