+ Reply to Thread
Results 1 to 4 of 4

If Value in Worksheet 1= "Completed" then copy set of cells values to second worksheet

  1. #1
    Registered User
    Join Date
    04-09-2013
    Location
    Mt barker,Western Australia
    MS-Off Ver
    Excel 2010
    Posts
    16

    If Value in Worksheet 1= "Completed" then copy set of cells values to second worksheet

    Hi All,
    My problem is If Value in Worksheet 1= "Completed" then copy set of cells values to second worksheet
    I have a summary page when dates staff have completed courses are displayed in cells D4 to K4 i have set up a macro that once all dates are in in cell N4 value of "Completed" is there.
    I wish to copy the cells with dates D4:K4 (Values) to employees own sheet and have the dates placed in a column D5:D20.

    First of all can this be done :P

    If anyone can help with code this would be great.

    Thanks in Advance

  2. #2
    Registered User
    Join Date
    04-30-2013
    Location
    Brussels
    MS-Off Ver
    Excel 2007
    Posts
    35

    Re: If Value in Worksheet 1= "Completed" then copy set of cells values to second worksheet

    Hello,

    No problem, this can be done.
    You will have to use VBA (macros).

    Here is a code example to put in your WORKSHEET 1:

    Please Login or Register  to view this content.
    Have fun !
    ExcelTab.com

  3. #3
    Registered User
    Join Date
    04-09-2013
    Location
    Mt barker,Western Australia
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: If Value in Worksheet 1= "Completed" then copy set of cells values to second worksheet

    Ok My Bad mucked up copy and pasting code
    However now thats sorted it isnt copying data to employee sheet.
    Forgive my ignorance but how does the code know what the target is ??

  4. #4
    Registered User
    Join Date
    04-30-2013
    Location
    Brussels
    MS-Off Ver
    Excel 2007
    Posts
    35

    Re: If Value in Worksheet 1= "Completed" then copy set of cells values to second worksheet

    Hello HaccStaff,

    This is a Event macro, hence the code :
    Please Login or Register  to view this content.
    You need to paste this code on your Sheet code editor (not in a module).
    This macro will trigger everytime a cell is changed on your worksheet.
    To learn more about this, search for "Event Macros in Excel" on internet.


    The Target is the cell that you changed. For instance, if you type "Completed" in a cell, it will trigger your macro.

    Try it! And have fun!

+ 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