I need to put in one single worksheet the data of 800 worksheets in the same document

[RicardoChavez]

So, I have an excel workbook with 800+ worksheets and need to join them in one single worksheet. They are all of the same range. Dont know very well the macros so please help me step by step. I want to usea a loop or something like that so i dont have to put one by one the number of the sheets.

Thanks a lot.
Ricardo.

[RicardoChavez]

I attached a short version, the 800 sheet document was to long :D

[Norie]

Ricardo

How do you want to 'join' them?

Do you want all the data in columns A-D on a new worksheet?

Are there any sheets you don't want to join?

[RicardoChavez]

Hi Norie, i want to join all the data, the whole 800+ worksheets, in one single worksheet in columns A-D. I want all the sheets.

[Norie]

Try this.

Please Login or Register  to view this content.

[RicardoChavez]

Thanks a lot!! It worked just fine. I wish I could understand what you meant in every line lol