how to update data on sheet1 and have it auto update on sheet2

No problem, it wasn't that long ago I was asking the same thing. The
Worksheet_Change event, will fire code you specify whenever a cell is
changed. I've done this as a joke before to friends, I've coded so that
when they make a change in a cell, I get Excel to clear the cell
contents. It drives them crazy. To code the Worksheet_Change event, just
go something like this:

Private Sub Worksheet_Change(ByVal Target As Range)
Call Macro1
End Sub

Macro1 is the name of your macro to update the references.

*** Sent via Developersdex http://www.developersdex.com ***

do I just put this in my macro or do i use a new one. If in the one I have,
does it go at the beginning or end. Also how can I make my macro auto run,
when its open.

thank you



"Darrin Henshaw" wrote:

> No problem, it wasn't that long ago I was asking the same thing. The
> Worksheet_Change event, will fire code you specify whenever a cell is
> changed. I've done this as a joke before to friends, I've coded so that
> when they make a change in a cell, I get Excel to clear the cell
> contents. It drives them crazy. To code the Worksheet_Change event, just
> go something like this:
>
> Private Sub Worksheet_Change(ByVal Target As Range)
> Call Macro1
> End Sub
>
> Macro1 is the name of your macro to update the references.
>
> *** Sent via Developersdex http://www.developersdex.com ***
>

Please check out what I am going to tell you to make sure it's true. If you put an event routine in a general code module the routine will not be triggered by the event. I think that the event routine has to be in the code space for the specific sheet where the event occurs- in the VB Project window right-click on the sheet name then "view code." I think I read this info on this forum.