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?
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,
Thank you Marco! exactly what i needed to know!