Hi everyone
Finally after trying hard for the whole day, i am finally posting my problem.
I have a sheet in which there are multiple tables ( can be even 400 tables in a sheet). Each table has a different column heading. Now i want to compile whole of the data into List format so that i can use Pivot tables & other tools to do advance analysis of the Data.
I am attaching herewith a Sample sheet in which there are 2 sheets. One is the Input sheet & the other is output sheet, the format in which i need the output.
I would appreciate if someone can help me with some macro which can collect data from multiple tables in a sheet & make a list of the same. It would be great if the macro works even if the size of the tables differs from each other.
Please help as i need to convert about 1000 tables ( multiple files ) to list & do analysis & submit the same in 2 days
Bookmarks