Results 1 to 13 of 13

Copy Range from Sheet2 to Sheet1 through VBA

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-19-2011
    Location
    Central Europe
    MS-Off Ver
    Excel O365
    Posts
    364

    Copy Range from Sheet2 to Sheet1 through VBA

    Hi everyone

    I am sure it's really simple, but even through Google I did not manage to come across a helpful Code for the life of me

    What I basicly need is that Excel copies the Range B:I from Sheet2 to Sheet1 whenever data is entered in Sheet2.

    Note that Sheet1 will be hidden for the user.

    At the same time the value for A:A in sheet1 should be filled in by looking up the value of A:A in Sheet2 and replace it with the value defined in Sheet3
    (allthough once I know how to get the first part this will be easy)


    Edit: I should note, that if a user changes the value of any cell, the value in Sheet1 should change as well

    Anyone who could help?

    Thanks
    FD
    Last edited by FallingDown; 10-26-2012 at 08:31 AM. Reason: Provide more Info

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