Makes much more sense, yes.
Ok, cell A1 must have the word "Title" on it before this macro will create the OUTPUT sheet. Make sure that data sheet is onscreen. Data must be in the two-column format demonstrated in your last workbook.
I've also adjusted the output, row/column intersection where the same name appears will only show values if they are the sole author of one or more publications, the table as a whole represents:
1) Number of time row/column intersecting authors co-authored publications
2) Number of times an author was the sole author of a publication. (See Miller, Lisa A. as an example)
The macro is CreateRelationalAuthorTable and goes in a standard code module.
Bookmarks