Hi Charles Great to know you are safe. Regarding the copy paste, I think you are just doing normal Control + C and Control + V which will copy the formulae Please try paste special - paste values, when you paste on to the summary sheet
Paste values In MS Excel : Copy and paste specific cell contents | | | | Copy and paste specific cell contents | | | Paste values In Libre Office calc : Paste Special | | | | Paste Special | | | Hope this helps regardsHastham / Subu On Friday, October 21, 2022 at 09:10:07 PM GMT+4, charles meyer <reachmepl...@gmail.com> wrote: Hi All, So grateful to have survived Hurricane Ian and to be able to help others in the community. It seems Excel isn’t as straight forward as I’d like. Perhaps this is easier to do in Calc? I opened a blank worksheet and thought I’d create the first column of rows with each cell populated with the name each a story. I then created columns with the heading of the name of each judge. So, 50 rows (each story) and 4 columns comprised of each judge name and then the last column named Total for total of points summed from each of the judge’s scores. When I copy by highlighting all the score numbers from a judge’s total score column and the paste those scores into the 1st cell under the column for that judge I get #REF! in each cell. Is there a way to copy all those judge’s scores from each judge’s scoring worksheet and pates them into a column for that judge in a new worksheet so I have all the scores from all the judges and in the 4th column I can just Click that Z Sum tab to add all 3 scores for each story (and then hopefully sort them by highest score to lowest? I’ve never taken any Excel nor Calc class which taught this. Thank you so much. Best, Charles. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy