Hi All,
I need to automate a excel sheet having list of FTE working for the different clusters and send the reports via mail.
In my team around 10 people extracting the same report and sending it to the stakeholders based on the cluster.
Whereas instead of 10 people extracting the report separately one person can extract the report from the system and split it according to the cluster and send it to each team member and then they can send it to their stake holders.
Herewith have attached the dummy report for refrence.
I am in need of VBA code where we need to split the report based on the cluster on the Column A.
Thanks in Advance
Aravind
Bookmarks