[RNLD] Putting together multiple spreadsheets

[Thiago Chacon]

Thank you all for your help.

I needed it with some urgency, so ended up copying and pasting everything manually.

Best
thiago 

> Date: Sun, 18 May 2014 04:59:25 -0400
> Subject: Re: [RNLD] Putting together multiple spreadsheets
> From: frank.zidle at gmail.com
> To: thiago_chacon at hotmail.com
> 
> Dear all,
> 
> I am sorry about the sent email, I pressed must heave touched the
> touchpad while the arrow was on the send button.
> 
> Thiago,
> what I wanted to say, that doing it manually (i.e. copying everyting
> by hand into one worksheet) using shortcuts (CTRL + C etc.) should not
> take you that long. I would think half an hour or so. It is probably
> better than writing code and testing and rewriting code etc.
> 
> Good luck,
> 
> Frank
> 
> On 5/18/14, Frank Seidel <frank.zidle at gmail.com> wrote:
> > Hello Thiago,
> >
> > have you tried the consolidate command in Excel? Would that not work
> > for you? There are several websites out there with tips on how to
> > combine or consolidate worksheets into one
> > Otherwise doing it manually (copyshouldn't Good luck,
> >
> > Frank
> >
> > On 5/15/14, Thiago Chacon <thiago_chacon at hotmail.com> wrote:
> >> Dear all,
> >>
> >> I have a lexical comparative database on Tukanoan languages a single
> >> EXCEL
> >> file, but in multiple sheets (197 in total) in the document.
> >>
> >> 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)
> >>
> >> 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.
> >>
> >> 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...
> >>
> >> 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.
> >>
> >> thanks
> >> Thiago Chacon
> >>
> >>
> >>
> >>
> >>  		 	   		
> >
> >
> > --
> > Frank Seidel, Ph.D.
> > University of Florida
> > Center for African Studies at the University of Florida
> > 427 Grinter Hall - PO Box 115560
> > Gainesville, FL 32611-5560
> > Tel: 352.392.2183
> > Fax: 352.392.2435
> >
> 
> 
> -- 
> Frank Seidel, Ph.D.
> University of Florida
> Center for African Studies at the University of Florida
> 427 Grinter Hall - PO Box 115560
> Gainesville, FL 32611-5560
> Tel: 352.392.2183
> Fax: 352.392.2435
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listserv.linguistlist.org/pipermail/resource-network-linguistic-diversity/attachments/20140519/2fa1474f/attachment.html>