consolidate/sum ranges cell for cell

[Kaizan]

Hi Again guys,

I have another question.

I have a Workbook with a master sheet and a button to import four sheet from another workbook.
I would like to consolidate a specific range in sheet two of the newly imported four sheets and consolidate and sum range B3:Z9 cell for cell not as a full range and and paste them into B3:Z9 in the master sheet.

e.g cell SheetB3 + SheetB3 = Put in B3 in master and so on for B4, B5....

Another problem is that sometimes 2 x four sheet is imported and sometime 3 x four sheet is imported.
the range is always the same, however sheet name of the four is always different and the number of sheets imported can vary.

I was thinking about doing it like this.

Please Login or Register  to view this content.

However I don't think this is the way to go.
Help is really appreciated

[Kaper]

If a number of sheets before import is constant (say 3) and you import new sheets to be inserted after already existing sheets you may use:

Please Login or Register  to view this content.

If a number of sheets before import varies and you import new sheets to be inserted after already existing sheets you may use:

Please Login or Register  to view this content.

[Kaizan]

Hi Kaper,

Thank you could you also advise on the actual consolidation ?

Thanks



E.g

Please Login or Register  to view this content.

Sum all cells, cell for cell for a specific range to a already existing master sheet called "Resources" from the sheets For i = sheetsbeforeimport + 1 To Worksheets.Count

[Kaper]

Is there already something in cells G11 etc in "Master" sheet?
if so, I'd probably do it this way:

Please Login or Register  to view this content.

If G11 is empty the above shall also work, but I'd probably insert in G11 a 3d-sum through all added worksheets formula, copy to all needed cells and then copy and paste special as values only.

It is all the time a bit vague, because there is no sample attachment file (see yellow box above first post) :-)

[Kaizan]

Thanks Kaper.. For better transperancy I added:

I have a lot of sheets in a workbook named SomethingA - Resources SomethingB - Resources SomethingC - Resources etc...................

I am trying to sum a specific range inside every one of these sheets which will change variable before the dash in the name and the amount of sheet will change. I would like the sum to appear in a sheet called "Resources" which i the first sheet in the workbook. My code so far after using you initial idea:

Please Login or Register  to view this content.

[Kaper]

see yellow box

[Kaizan]

Sorry about that actually thought it was attached

[Kaper]

Sorry, I cant see sample data and expected result in sample file