Help with autoupdate....

[vcobra57]

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.

 

[Guest]

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

 

[Tom Ogilvy]

Use the change event in sheet1 to write the data to sheet 2 or put a button
on sheet1 that updates the data on sheet2 when pressed.

Chip Pearson's page on events
http://www.cpearson.com/excel/events.htm

Other than that, with no knowledge of how your sheet is laid out or when you
would want the action to take place or otherwise how to trigger the action,
not much can be offered.