View original (French)

CALC copy a cell to another sheet

hamire50 Posted messages 5 Status Member -  
hamire50 Posted messages 5 Status Member -

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 answers

  1.
    brucine Posted messages 24834 Registration date   Status Member Last intervention   4 166
     

    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.

    0
    1. hamire50 Posted messages 5 Status Member
       

      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.

      0
  2. yclik Posted messages 3874 Registration date   Status Member Last intervention   1 609
     

    Hello

    The syntax is of this type

     ='file:///D:/My documents/OOo help/calc/linked workbook/Student_source.ods'#$Sheet1.$D$3

    Check the exact syntax on Mac; the separators  / might be different

    0
    1. hamire50 Posted messages 5 Status Member
       

      Thank you for your response, but I don't quite understand. Do I need to copy the entire path?

      Reading the formula, I have the impression that it involves 2 linked workbooks. In my case, the 2 sheets are in the same workbook.

      0
  3. yclik Posted messages 3874 Registration date   Status Member Last intervention   1 609
     

    hello

    sorry, I didn't read it well

    so the syntax is

    =sam_midi.A2

    to build the formula there is also the possibility

    • to enter = in the cell
    • to point in the source sheet to the source cell
    • to validate (enter)
    0
  4. hamire50 Posted messages 5 Status Member
     

    A big thank you

    0
  6. hamire50 Posted messages 5 Status Member
     

    A big thank you, yclik. The formula is good.

    0