Macro for making summary page of all the tabs in excel file

Hi,

I am trying to make a Macro Which can consolidate the data from all the tab of the sheet and will collate it in new sheet Summary and also format the summary page.

Could you kindly help me with the below macro as it is giving me issue and I am not able to format it.

Please find the sample file attached with the data and the required output format (Summary Tab)
Few issue, the data in the tabs is dynamic, Rows can be of any range

In summary tab, there has to be colour formating and headers needs to made for all the tabs,

Col F, G and H needs to be sorted based on largest to smallest so that True comes firt and entire Row can be coloured as per the Row colour

Could you please help me with the same, I tried lot of codes but was not able to make it.

Thanks a lot in advance.

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

HI John,

Thanks for the Macro, still have some issue

The data is dynamic in nature, there could be instance in particular column the data is till Row no 10 and in other column data is till row no 11, because of which the next heading is getting displayed on the wrong column.

Also there could be instance where all the tabs need not be used for consolidation , so can be incorporate Split function, so that the required tabs can be incorporated.

Thanks

Akshay

Morning Akshay.

Can you provide a sample which outlines some of the possibilities. I only tested on the sample provided.

Originally Posted by akshay8530

HI John,

Thanks for the Macro, still have some issue

The data is dynamic in nature, there could be instance in particular column the data is till Row no 10 and in other column data is till row no 11, because of which the next heading is getting displayed on the wrong column.

Also there could be instance where all the tabs need not be used for consolidation , so can be incorporate Split function, so that the required tabs can be incorporated.

Thanks

Akshay

Try this. I don't know how to indicate which Tabs to exclude without knowing the Tab names.

Please Login or Register  to view this content.

Hi John,

Thanks a lot for the prompt response.

Also please find the revised sample file attached.

Regards,

Akshay

Hi John,

I tried the revised Macro, there is an issue with the headings which are not aligned if the data in the last row in the column is missing for any of the tab
Please note all column can be variable except column A, Means if there is name in Col A , than there will be data in any or all column cells for the row.
There will also be one more col with comments in the summary tab at the last

Also the tabs which needs to be excluded are sample 1, sample 2 and sample 3

Regards,

Akshay

Try this then?

Please Login or Register  to view this content.

Hi John,

Thanks a lot for your support and help

You're welcome. Glad to help out and thanks for the feedback.