Provide total items + amounts when compile data in multiple worksheet + alignment (part 2)

[jamewoong]

Because the main question is resolved by jaslake, I need to create a new thread because I want to add new things to complete my template.

Here is the main thread:
http://www.excelforum.com/excel-prog...worksheet.html

Previosu working code was:

Please Login or Register  to view this content.

It will work with the 3 tabs in the workbook. Now, I am trying to extend it even more. I added 3 extra tabs (Reports 4-5-6). What should I amend to the code so the Report 1-2-3 is one set and Report 4-5-6 is another set?

Report 1 will have the NET total of Report 1-2-3 (since Reports 2 and 3 is referred to Report 1)
Report 4 will have the NET Total of Report 4-5-6 (since Reports 5 and 6 is referred to Report 4)

So, the code for D4 and H5 on both Report 1 and 4 needs to be amended to take effect. In addition, I want the "Total Items:" in E will be aligned to the "Text Right"; the number of item in F will be Text Centered. And one last thing, the number of item in H

What to amend?

Thanks

Reports XYZ (Part 2).xlsm

[jaslake]

Hi jamewoong

Are the ACTUAL Sheet Names "Report 1", "Report 2", "Report 3", "Report 4", etc.?

Alternately, are the ACTUAL Tabs in sequence of how you wish them grouped ("Report 1", "Report 2", "Report 3") then ("Report 4", "Report 5", "Report 6")?

Will you be adding additional Worksheets? Will they ALWAYS be in Groups of three? Will they ALWAYS be in sequence?

[jamewoong]

Hi jamewoong

Are the ACTUAL Sheet Names "Report 1", "Report 2", "Report 3", "Report 4", etc.?

Alternately, are the ACTUAL Tabs in sequence of how you wish them grouped ("Report 1", "Report 2", "Report 3") then ("Report 4", "Report 5", "Report 6")?

Will you be adding additional Worksheets? Will they ALWAYS be in Groups of three? Will they ALWAYS be in sequence?

Hi Jaslake,

These are the real format tab name. Report 1-3 contains data from a particular set ; Report 4-5 from another set which I remove the code since it has no purpose.

Once data is compiled, it will print page Report 1-3 and pages Report 4-6.

Only 6 reports, no extra tab will be added.

[jaslake]

Hi jamewoong

Try this Code in the attached...

Please Login or Register  to view this content.

[jamewoong]

Thanks jaslake! I tried to amend it yesterday without success. Now checking your code, I get a better knowledge because I need to assign the variable "i" from 1 to 3 ; and 4 to 6...

Just learn something! Thanks! :D

[jaslake]

You're welcome...glad I could help.

If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.