+ Reply to Thread
Results 1 to 3 of 3

Automatically move data to another sheet

  1. #1
    Registered User
    Join Date
    08-10-2006
    Posts
    58

    Automatically move data to another sheet

    Hi Everyone,
    I've learned so much from everyone about vba, hopefully I'll be able to start contributing back soon! Here is my latest question... I am trying to automatically have data transferred from sheet1 to sheet2 after it is entered without having to press a button to trigger it.

    The part I need help with is the automatic triggering. I can write the program to actually move the data how I need it, I just don't want to have to do anything special to make the transfer occur. Any suggestions?

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,483
    Private Sub Worksheet_Change(ByVal Target As Range)

    End Sub
    Check it out, it is in the worksheet module

    Lots of info in the forums about it

  3. #3
    Registered User
    Join Date
    08-10-2006
    Posts
    58
    Thanks, I knew it had been discussed before, I just couldn't find anything. I tried about 5 different search strings with either 100's of results, or 5 irrelevant results.

    Jeff

+ 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