I need a macro that can extract tables from the attached spreadsheet (Worksheet name is Trial_Sheet and sheet name is “sample”) and create multiple tabs with Tab names as the first element of the table and copy the individual tables to separate worksheets as shown in the attached workbook. The first elements from the tables are Table1, Table2, Table3 and Table4.
Please note that in the actual spreadsheet the amount of table are not known. It could be up to 50 tables arranged in no particular order except spaces between the table (I think CurrentRegion should work but not sure) Is this possible?
Once this has been achieved can it export the contents of the various tabs except the “sample” tab to a PowerPoint?
Thank you so much for the help.
Please note that in the actual spreadsheet the amount of table are not known. It could be up to 50 tables arranged in no particular order except spaces between the table (I think CurrentRegion should work but not sure) Is this possible?
Once this has been achieved can it export the contents of the various tabs except the “sample” tab to a PowerPoint?
Thank you so much for the help.