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 [email protected] -- To unsubscribe e-mail to: [email protected] 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
