Forum Home
Press F1
 
Thread ID: 9696 2001-06-10 22:37:00 Excel Guest (0) Press F1
Post ID Timestamp Content User
13952 2001-06-10 22:37:00 Hi
I just need to know hoe to enter data in a cell and have it appear in another sheet in the same workbook.
Thanks for the help
Guest (0)
13953 2001-06-10 23:37:00 Hilite the cell on the worksheet where you want the data cell's information to appear
type = without pressing <enter>
click on the worksheet tab of the data cell then click on the data cell itself, and press <enter>.
The formula will then appear - in the format =WorksheetName!CellAddress

HTH
Guest (0)
1