5 Replies Latest reply on Jun 25, 2013 10:48 AM by Brad Llewellyn

    Transferring values from one sheet to another

    Brad Llewellyn

      Is it possible to calculate a value on 1 sheet then pull that value as a constant onto another sheet?  A small example is below:

       

      Data:

       

      Price     Quantity

      1                 1

      1                 2

      1                 3

      2                 4

      2                 5

      2                 6

       

      Sheet 1:

       

      Text Table

                               __________

      Sum of Quantity |              21

                             

      Sheet 2:

       

      Text Table

       

      Price     |  Total Sum of Quantity (constant)

      1           |                                           21

      2           |                                           21

       

      I realize that this case could be solved with a custom calculation.  However, the more complicated problem I am dealing with is not nearly so simple.