Dear All,
In rows 1 to 4 and sometimes 1 to 5, I have names each associated with a number(s) in brackets.
In line 9 and bellow a list of universities and research institutions representing the numbers after the names of authors.
I need a VBA that can distribute (Copy) the names in rows 1-to 5 into their respected organization (line 9 and bellow).
Please note that some names are associated with more than on organization (E.g. C1 or D2, B3 shaded in green) in this case, Ideally the same name should appear in front of each organization he/she belongs to.
Alternatively a formula that I can copy down and across will do.
Please see the attached file of many that I have to deal with,
Many thanks and appreciation in advance
Bookmarks