Dear Excel community,
I'll like to compare excel data.
These Excel tables are extended or reduced monthly, making it difficult to compare.
Here is an example of an Excel sheet before using the macro.
The table columns are not so important.
The names of the lines in the first column that are to be the order criterion are much more important. They're marked in yellow.
Here is the BEFORE-Sheet:
http://www.evernote.com/l/AGDXuafuCe...6MvJYVFkKlO3c/
The VBA should now always compare the first column with the column that has the most content in common (here is column M). The contents of the columns should then be distributed in such a way that the columns with the same row labels are listed in one row and thus become comparable. No lines may be lost even if they are not comparable with others.
More than 2 data sets can be compared, unlike in the example. sometimes it can be up to 12 data sets per sheet.
The number of columns that belong to a data set can also vary.
Columns A-K and M-W are to be understood as data sets.
Here is the AFTER-Sheet
http://www.evernote.com/l/AGDXuafuCe...6MvJYVFkKlO3c/
I have attached an Excel Sheet in the Links,
Thank you very much for your Suggestions
Bookmarks