Different Worksheets with Similar name issues

[narkissos]

Hi everyone,

One week ago I started using VBA in order to improve some Excel files from my company. The Excel file we use Works like this: We analyze several spots, and every spot needs 4 worksheets. When we analyze the second spot, we press a button and 4 more worksheets appear. So we end up having:

Intro

First
Second
Third
Fourth
First (2)
Second (2)
Third(2)
Fourth(2)
Final

* If you press again the button, you will have the following worksheets:

First
Second
Third
Fourth
First (3)
Second (3)
Third(3)
Fourth(3)
First (2)
Second (2)
Third(2)
Fourth(2)
Final

* It is okay to have the (3) before the (2), it is easier to work with this workbook if it Works like this.

The thing is: The First, Second and Third worksheets are used to get some info in the Fourth (n) Workbook. So What you need is the range C2:Z732 in every fourth workbook.

Then, what i need is to sum every C2:Z732 from every worksheet which name includes "Fourth" to the "Final" Worksheet.

I have tried to create some loops but i haven't been able to acquire any good result.


Thank you very much for your help.

[nilem]

Hi narkissos,
maybe something like this

Please Login or Register  to view this content.

And please
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between

Please Login or Register  to view this content.

tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

[narkissos]

Hi Nilem,

First of all thank you very much for your help and sorry about the Rule 3.

Unfortunately, this macro doesn't exactly do what i'm looking for.

As you may imagine, every Fourth Worksheet have a matrix of 24h x 2 years of info (the C2:Z732).

What I want is the Final worksheet to still have the C2:Z732 configuration, just that every cell in the Range C2:Z732 is actually the sum of the same cell in the Fourth's Worksheets.

I imagine I haven't expressed myself correctly.

Thank you very much for your help!


Edit: Right now what it does is copy the Sum of every Fourth C2:Z732 in a different cell.

[nilem]

Narkissos, please add the tag code in your first post (or better remove the code from your post)

[narkissos]

Done! Sorry, new here >.<

[nilem]

Thanks
and try it

Please Login or Register  to view this content.

[narkissos]

It works like a charm.

THANK YOU!!!!

I'll try to understand everything you've done here.

Thank you very much. Really!