2 Replies Latest reply on Mar 19, 2013 4:14 PM by aislingaran

    Linking cells between 2 worksheets

    aislingaran

      Is there a way to link a cell in an added worksheet to the All Responses worksheet generated by an Adobe Form? For example, If I have a response in cell A1, i can copy it into column B by entering =A1. But what if I want to copy it into column B on a second worksheet I created? I have tried typing = and then clicking the cell on the first worksheet, as I would in Excel, but it does not work.

       

      Any advice? Is there a way to refer to another worksheet?

       

      thanks

        • 1. Re: Linking cells between 2 worksheets
          Marco Qualizza Adobe Employee

          Hello aislingaran,

           

          Unfortunately, clicking on a cell on another sheet doesn't work as well as clicking on a cell in the same table, or on a cell in another table on the same sheet.

           

          The sheet first created with your form is called "All Responses", and the response table on that sheet is called "Response Table".  To refer to A1 from another sheet, you can either use Excel-style references:

          = All Responses!Response Table!A1

           

          or Numbers-style references:

          = All Responses::Response Table::A1

           

          (Note: If you were making the reference from another table on the same sheet, you would use "= Response Table!A1" or "= Response Table::A1").

           

          I hope this helps,

          Marco

          • 2. Re: Linking cells between 2 worksheets
            aislingaran Level 1

            Thank you Marco! exactly what i needed to know!

             

            -Kimberly