+ Reply to Thread
Results 1 to 8 of 8

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

  1. #1
    Tommy
    Guest

    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. #2
    Alok
    Guest

    RE: 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. #3
    Darrin Henshaw
    Guest

    Re: 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. #4
    Tommy
    Guest

    Re: 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. #5
    Darrin Henshaw
    Guest

    Re: 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. #6
    Tom Ogilvy
    Guest

    Re: 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" <[email protected]> wrote in message
    news:[email protected]...
    > 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. #7
    Tommy
    Guest

    Re: 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 ***
    >


  8. #8
    Registered User
    Join Date
    04-07-2005
    Posts
    14
    Please check out what I am going to tell you to make sure it's true. If you put an event routine in a general code module the routine will not be triggered by the event. I think that the event routine has to be in the code space for the specific sheet where the event occurs- in the VB Project window right-click on the sheet name then "view code." I think I read this info on this forum.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1