Hi :) There's an even easier way! Sorry this is probably too late! :( 1. Open both files but get into the one you want to copy from 2. Right-click on the tab at the bottom of the work-sheet 3. Choose "Move or Copy worksheet" 4. in the dialogue choose "copy" and use the drop-down to select the other file.
I suspect you can do multiple worksheets/tabs at a time. Of course another way is to simply copy the entire file and then you have all the tabs/worksheets in the new file. Maybe need to add or delete a couple. Regards from Tom :) On 2 January 2015 at 01:35, Fred James <fredj...@fredjame.cnc.net> wrote: > OS: Mageia 4, 64bit (if that makes a difference?) > LibreOffice: 4.1.6.2 > > I have two separate ODS files: 2014 and 2015 > > I want to copy a sheet (the entire sheet) from 2014 to 2015. > > Is this possible, and if so, what is the recommended method? > > Actually, there are a few sheets I want to copy from 2014 to 2015, but one > at a time. > > Thank you > Regards > Fred James > > Sorry ... silly me ... the answer is too easy ... > 1) go to file to copy from > 2) go to the sheet to copy > 3) Edit -> Select All > 4) go to file to paste into > 5) go to (or make) sheet to paste into > 6) select cell A1 > 7) Edit -> Paste Special > Bingo! > > Thanks > Regards > Fred James > > > -- > To unsubscribe e-mail to: users+unsubscr...@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 > -- To unsubscribe e-mail to: users+unsubscr...@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