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

"Tommy" wrote:

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