ExcelBanter - View Single Post - Automaticall pick up info from a cell from a shet t oanither sheet , in the same cell, same book

[email protected]

wrote:
Gord Dibben wrote:
I may have misinterpreted but..............

In Sheet2 select A1 and enter =Sheet1!A1

Gord Dibben MS Excel MVP

On 17 Dec 2006 13:26:05 -0800, 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?

Thanks.

There is one more twist to this question.
Unfortunately, I am sending on esheet each to the user. For example, IN
2006 I created this workbook. Now I am sending the 2007 sheet. What can
I do to the 2007 sheet so the name and ID # filed is automatically
picked up from the 2006 sheet? I don't think that all users have given
the same name to 2006 sheet. So a macro that looks for the infor froma
particular location and the sheet that is in front of 2007?

Thanks