Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to update data on sheet1 and have it auto update on sheet2
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to update data on sheet1 and have it auto update on sheet2
You could look at running the macro via the Worksheet_Change event. That
will fire the macro whenever a cell is changed. *** Sent via Developersdex http://www.developersdex.com *** |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to update data on sheet1 and have it auto update on sheet2
I hate to ask but what is Worksheet_Change event.
Thank You "Darrin Henshaw" wrote: You could look at running the macro via the Worksheet_Change event. That will fire the macro whenever a cell is changed. *** Sent via Developersdex http://www.developersdex.com *** |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to update data on sheet1 and have it auto update on sheet2
http://www.cpearson.com/excel/events.htm
Chip Pearson's page on events should help as well. -- Regards, Tom Ogilvy "Tommy" wrote in message ... I hate to ask but what is Worksheet_Change event. Thank You "Darrin Henshaw" wrote: You could look at running the macro via the Worksheet_Change event. That will fire the macro whenever a cell is changed. *** Sent via Developersdex http://www.developersdex.com *** |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to update data on sheet1 and have it auto update on sheet2
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 *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to sheet1 data goes to sheet2 automaticaly ? | Excel Worksheet Functions | |||
copy data from sheet2 to sheet1 when sheet2 has variable # of rows | Excel Discussion (Misc queries) | |||
Compare and Update elements from Sheet1 with Sheet2 | New Users to Excel | |||
How To Retrieve Data from Sheet2 into Sheet1 | Excel Worksheet Functions | |||
Transfer data from sheet1 to sheet2 | Excel Programming |