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. -- 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
