LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 70
Default how to update data on sheet1 and have it auto update on sheet2

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to sheet1 data goes to sheet2 automaticaly ? ABDUSSALAM Excel Worksheet Functions 2 March 10th 10 04:12 PM
copy data from sheet2 to sheet1 when sheet2 has variable # of rows Anne Excel Discussion (Misc queries) 6 February 27th 09 09:48 PM
Compare and Update elements from Sheet1 with Sheet2 [email protected] New Users to Excel 3 November 27th 07 04:27 PM
How To Retrieve Data from Sheet2 into Sheet1 compconnj Excel Worksheet Functions 3 March 21st 06 07:56 PM
Transfer data from sheet1 to sheet2 Tommy Excel Programming 6 May 11th 05 06:39 PM


All times are GMT +1. The time now is 01:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"