Sorting and adding sub-totals

[siddharthnk]

Hi Mr. Excel community,


I have been performing a daily task at work. On a spreadsheet there are several tables. I need to automate this repetitive task using excel macros


All the tables have their first column in A
The number of tables may vary
All the tables have atleast the following columns in common Budiv, Sector, Sub sector, SL Bkgs and Opty Bkgs
The macro needs to sort all the tables by sub-sector column and add subtotals for the columns SL Bkgs and Opty Bkgs
The subtotals then need to have yellow cell color and bold black text

Any help will be greatly appreciated.

Thanks and regards,
Sidd