From sheet 2, in the cell where you want to have the value appear, enter "="
then navigate to sheet 1 and click the cell where the data was entered. You
will end up with something like the following:

"=Sheet1!A3"

I hope that helps!

Kevin

"vcobra57" wrote:


Hi Guys,

Here's the deal. Thanks a million in advance for your help.

I have like a template in Sheet1. I enter some basic date such as date,
name, etc...

In sheet2, I want this date I entered in sheet1 to be stored. For
everytime I enter data in Sheet1 template, I want it to be updated in a
different row in Sheet2.


--
vcobra57


------------------------------------------------------------------------
vcobra57's Profile: http://www.excelforum.com/member.php...fo&userid=4217
View this thread: http://www.excelforum.com/showthread...hreadid=277438