I have a excel summary report which has different tables under different headings. I need to split the tables under each heading into separate data sheet based on headings and name each tab with the heading.
Attached is my excel file, it has summary tab from which I need to fetch data and then split them into multiple pages based on headings and name each tab with the heading as shown in the sample file.
output.xlsx (12.3 KB)
Any help or xaml will definitely keep me going forwardwould be appreciated.