<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Dear all,<BR> <BR>I have a lexical comparative database on Tukanoan languages a single EXCEL file, but in multiple sheets (197 in total) in the document. <BR> <BR>I have data for 25 languages, separated in unique columns in each sheet plus a gloss column. (the columns for each language do not have a fixed location across the diferente sheets)<BR> <BR>I want to collapse all sheets into a single one, having the gloss column to sort all other columns alphabetically. This will allow me to identify identical glosses and unify them into a single row.<BR> <BR>Do you guys have any suggestions for how I could that? Is there something developed for similar purposes out there? I regret not being really savy in programming...<BR> <BR>Also, since the columns for each language are not in a fixed location across the diferente sheets, I wonder if I ahev to fix that manually or the MACRO could help me with that as well.<BR> <BR>thanks<BR>Thiago Chacon<br> <BR>
</div></body>
</html>