CALC copy a cell to another sheet
hamire50 Posted messages 5 Status Membre -
Hello,
I am using LibreOffice on macOS Sonoma 14.2.1. I would like to copy the calculated result in a cell to cells in another sheet of the same workbook.
I will explain my project. I created a workbook to calculate the budget for a family reunion over several days and the participants' attendance at meals, knowing that not everyone will be present for the same meals.
I have created a sheet for each meal (sat_lunch, sat_dinner, sun_lunch, etc.) and a "guests" sheet with a list of people on which I indicate their attendance at the meals. I would like to copy the cost of each meal (= source cell) to the cells in the "guests" sheet (= destination cells).
While searching, I saw that I needed to copy the formula ='name of the destination sheet'!reference of the source cell. Example: 'sun_lunch'!F24
This is not working: in my destination cell, I get: #NAME ?
I hope I have been clear. Can anyone help me? Thank you in advance.
5 réponses
Hello,
In Excel, to check with LibreOffice, the syntax is not in quotation marks and refers, of course, to the source sheet and not the destination.
In my new guests sheet, I write =dim_midi!F24.
If I don't want to write a long formula, I position myself in the destination guests cell, I type = and navigate to the source cell: the appropriate formula will be written automatically.
Thank you for your reply, but it doesn't work. The formula appears as is in the window, not the result of the source cell.