Re: [libreoffice-users] [Calc] Combining data coming from several sheets into a single sheet

On Mon, 2013-11-04 at 19:06 +0100, gordom wrote:
> W dniu 2013-11-04 18:53, Jay Lozier pisze:
> > On Mon, 2013-11-04 at 18:30 +0100, gordom wrote:
> > > Hallo everyone.
> > > I have a Calc document consisting of dozens of sheets. Each sheet has
> > > several rows (the number varies) and 4 columns of text strings. Now I
> > > need to combine all these text into one single sheet. Every next sheet
> > > (group of records) must be added bellow the previous one. Not only that,
> > > but I have to add an extra column with the reference to the name of the
> > > sheet that each record (text string) originally comes from. How can I
> > > achieve that? I would appreciate any help. Best regards,
> > > gordom
> > Gordom,
> >
> > You can use the following formula to reference the data in another
> > sheet:
> > If the final sheet is named output and the data is in a sheet named
> > data_2012, in any cell in output enter =data_2012.<cellreference>. The
> > cellreference is A1, B3 etc.
>
> It seems I didn't express myself clearly enough. What I want to achieve 
> is one single sheet consisting of all text strings (that are originally 
> located in different sheets) together with the name of the sheet where 
> each string was originally located.

Cut and pasting will work with page delete, if a bit tedious.

Otherwise a macro that automates the cut and pasting with empty page delete.

-- 
Jay Lozier
jslozier@gmail.com


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted