2.59 FAQ-502 how do I take the value in a report to use in my worksheet
Last Update: 7/8/2018
Select the cell(s) you wish to copy and choose Edit: Copy or press Ctrl+C. (Only one, contiguous selection is supported.) Click in the target cell and choose Edit: Paste Link or press Alt+Ctrl+V. These menus are also available from the context menu, opened by right-clicking on a worksheet cell. If you want to transpose the data when pasting, there is also Edit: Paste Link Transpose and context menu.
If you were to edit a worksheet cell that has a linked value in it, you'll notice the notation that is used. For example, if you copy the value in row 6 of column A, then you would see the following: cell://A. If you change the value in cell A, all cells that have cell://A will display the updated value.
For more details, see Inserting Links into Worksheet Cells.
Keywords:value, information, reference, report, copy, paste, link, auto, update, result, parameter