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

[Guest]

when I input new numbers on sheet1 i want it to auto update on sheet2, what
do I have to do. I have a macro that I can manually do, but I would like to
make it auto update. here is what I'm doing. Again I just want it to auto
run the macro, i believe, when I input any new number.
a b c d
Gorg, Ron 75 7 68
Haney, Wayne 81 11 70
Wilkshire, Bill 82 12 70
Browne, David 84 14 70
Alcorn, Jack 86 16 70
Kucharski, Vic 86 18 68
Wilkshire, Bob 86 0 86
Dee, Marty 87 13 74
Jenkins, Jim 89 17 72
Chappell, Jim 90 0 90
O'neal, Hank 92 19 73
Bee, Frank 93 20 73
Hamm, Bob 93 22 71
Plunkett, Larry 93 15 78
Boles, Charlie 96 13 83
Alter, Dave 100 17 83
Vasquez, Mike 102 16 86
Ash, Bob 104 27 77
McDonald, Jay 109 37 72
Kelsoe, James 111 21 90
Ammons, Boats 29 -29

 

[Guest]

Tommy,

It is not completely clear as to what you want. If what you want is the same
information that you are putting on sheet1 to also appear on sheet2 then put
the following formula in cell A1 of sheet2

=Sheet1!A1

and then copy the formula across till column D and then down till as many
rows as you want.

Alok Joshi

 

[Darrin Henshaw]

You could look at running the macro via the Worksheet_Change event. That
will fire the macro whenever a cell is changed.

 

[Guest]

I hate to ask but what is Worksheet_Change event.
Thank You

 

[Darrin Henshaw]

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.

 

[Tom Ogilvy]

http://www.cpearson.com/excel/events.htm

Chip Pearson's page on events should help as well.

 

[Guest]

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