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
>