Hi, Thanks for the well wishes.
I highlighted the last column with all the total numbers of that judge's scoring for that judge. I then drag the highlighted numbers in each cell in each frew for that column down from the first to the last story. I right clicked and chose Copy. I then opened a blank worksheet and there are 2 (two) Paste Specials. I chose the 1st and it doesn't paste in the numbers so I then chose the 2nd Paste Special but that didn't paste in the numbers either. I'm not sure what's going wrong? Thanks. On Fri, Oct 21, 2022 at 1:44 PM Hastham S <hasth...@yahoo.com> wrote: > 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 > <https://support.microsoft.com/en-us/office/copy-and-paste-specific-cell-contents-a956b1c3-cd5a-4245-852c-42e8f83ffe71> > > Copy and paste specific cell contents > > > <https://support.microsoft.com/en-us/office/copy-and-paste-specific-cell-contents-a956b1c3-cd5a-4245-852c-42e8f83ffe71> > > Paste values In Libre Office calc : > Paste Special > <https://help.libreoffice.org/latest/ro/text/shared/01/02070000.html> > > Paste Special > > <https://help.libreoffice.org/latest/ro/text/shared/01/02070000.html> > > Hope this helps > > regards > Hastham / 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