<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'>Thank you all for your help.<br><br>I needed it with some urgency, so ended up copying and pasting everything manually.<br><br>Best<br>thiago <br><br><div>> Date: Sun, 18 May 2014 04:59:25 -0400<br>> Subject: Re: [RNLD] Putting together multiple spreadsheets<br>> From: frank.zidle@gmail.com<br>> To: thiago_chacon@hotmail.com<br>> <br>> Dear all,<br>> <br>> I am sorry about the sent email, I pressed must heave touched the<br>> touchpad while the arrow was on the send button.<br>> <br>> Thiago,<br>> what I wanted to say, that doing it manually (i.e. copying everyting<br>> by hand into one worksheet) using shortcuts (CTRL + C etc.) should not<br>> take you that long. I would think half an hour or so. It is probably<br>> better than writing code and testing and rewriting code etc.<br>> <br>> Good luck,<br>> <br>> Frank<br>> <br>> On 5/18/14, Frank Seidel <frank.zidle@gmail.com> wrote:<br>> > Hello Thiago,<br>> ><br>> > have you tried the consolidate command in Excel? Would that not work<br>> > for you? There are several websites out there with tips on how to<br>> > combine or consolidate worksheets into one<br>> > Otherwise doing it manually (copyshouldn't Good luck,<br>> ><br>> > Frank<br>> ><br>> > On 5/15/14, Thiago Chacon <thiago_chacon@hotmail.com> wrote:<br>> >> Dear all,<br>> >><br>> >> I have a lexical comparative database on Tukanoan languages a single<br>> >> EXCEL<br>> >> 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<br>> >> plus<br>> >> a gloss column. (the columns for each language do not have a fixed<br>> >> location<br>> >> across the diferente sheets)<br>> >><br>> >> I want to collapse all sheets into a single one, having the gloss column<br>> >> to<br>> >> sort all other columns alphabetically. This will allow me to identify<br>> >> 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<br>> >> developed for similar purposes out there? I regret not being really savy<br>> >> in<br>> >> programming...<br>> >><br>> >> Also, since the columns for each language are not in a fixed location<br>> >> across<br>> >> the diferente sheets, I wonder if I ahev to fix that manually or the<br>> >> MACRO<br>> >> could help me with that as well.<br>> >><br>> >> thanks<br>> >> Thiago Chacon<br>> >><br>> >><br>> >><br>> >><br>> >> <br>> ><br>> ><br>> > --<br>> > Frank Seidel, Ph.D.<br>> > University of Florida<br>> > Center for African Studies at the University of Florida<br>> > 427 Grinter Hall - PO Box 115560<br>> > Gainesville, FL 32611-5560<br>> > Tel: 352.392.2183<br>> > Fax: 352.392.2435<br>> ><br>> <br>> <br>> -- <br>> Frank Seidel, Ph.D.<br>> University of Florida<br>> Center for African Studies at the University of Florida<br>> 427 Grinter Hall - PO Box 115560<br>> Gainesville, FL 32611-5560<br>> Tel: 352.392.2183<br>> Fax: 352.392.2435<br></div> </div></body>
</html>