Is anybody know how to link multiple sheets in Numbers
link sheet1 to sheet2 as C1=Sheet 1::Table 4 :: B4+31 than sheet 3 A5=Sheet 2::Table 4 :: C1+Table 4 :: B20 and sheet 4 as A5=Sheet 3::Table 4 :: C1+Table 4 :: B20
But I would like the change from Sheet 2::Table 4 :: C1+Table 4 :: B20 to Sheet 3::Table 4 :: C1+Table 4 :: B20 in a subsequent sheet to be automatic when I past and copy the tables... Is it possible to do?
link sheet1 to sheet2 as C1=Sheet 1::Table 4 :: B4+31 than sheet 3 A5=Sheet 2::Table 4 :: C1+Table 4 :: B20 and sheet 4 as A5=Sheet 3::Table 4 :: C1+Table 4 :: B20
But I would like the change from Sheet 2::Table 4 :: C1+Table 4 :: B20 to Sheet 3::Table 4 :: C1+Table 4 :: B20 in a subsequent sheet to be automatic when I past and copy the tables... Is it possible to do?