If data is in sheet1 A1 =Sheet1!A1 in sheet 2.

To do this anywhere, where you want the data to show up type the = sign, the
tab to the sheet you want, click the cell that contains the data you want and
press enter.

--
-John
Please rate when your question is answered to help us and others know what
is helpful.


" wrote:

How do I pick up info from a cell from the sheet to the next sheet at
the same location and in th esame workbook?