+ Reply to Thread
Results 1 to 9 of 9

Macro to update Score Card Summary when the new staff add-in or existing staff deleted

  1. #1
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2013
    Posts
    696

    Macro to update Score Card Summary when the new staff add-in or existing staff deleted

    Hi,

    Can anyone help me to give an idea?

    I have 2 workbooks which are "Score card summary" and "Working Data" to be run on a monthly basis. Once the user press update button, Score in the working data will be auto populated into score card summary.

    I have created VBA code with specified range for that particular staffs. My problem is if the existing staff resigned, its data will be deleted, thus the specified row will be moved. The same thing will happen if the new staff join, the new data will be add-in.

    Thus, when the user press update button, the data will be wrongly populated. I want a macro to be able to update regardless changes made in the row data


    sample VBA code for one of the staff, Please refer attachment for all staffs

    Please Login or Register  to view this content.
    Regards,
    Farid
    Attached Files Attached Files
    Last edited by Faridwahidi; 05-08-2014 at 12:48 PM.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Macro to update Score Card Summary when the new staff add-in or existing staff deleted

    Hi Farid,

    I'll look at this tomorrow and try to help you then - thanks for asking!
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2013
    Posts
    696

    Re: Macro to update Score Card Summary when the new staff add-in or existing staff deleted

    Hi xladept,

    Have a nice day!

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Macro to update Score Card Summary when the new staff add-in or existing staff deleted

    Hi Farid,

    I just rewrote the routine - see if you like it:

    Please Login or Register  to view this content.

  5. #5
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2013
    Posts
    696

    Re: Macro to update Score Card Summary when the new staff add-in or existing staff deleted

    Hi Xladept,

    your code working fine and simplify my code. However, what I want if there is new staff joined, his/her name need to be entered into worksheets .

    how does macro will recognize the new worksheets and also the new name in summary list


    Regards,
    Farid

  6. #6
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Macro to update Score Card Summary when the new staff add-in or existing staff deleted

    Hi Farid,

    Thanks for the rep!

    The program looks at all the worksheets, how ever many there are.

    Did you want the program to make new rows on the Score Card??

  7. #7
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Macro to update Score Card Summary when the new staff add-in or existing staff deleted

    Hi Farid,

    This will build your Score Card from your Working Data every time

    Please Login or Register  to view this content.

  8. #8
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2013
    Posts
    696

    Re: Macro to update Score Card Summary when the new staff add-in or existing staff deleted

    Hi Xladept,

    Amazing code , You are really VBA expert !

    hopefully, you can assist me in future, thanks a lot.

  9. #9
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Macro to update Score Card Summary when the new staff add-in or existing staff deleted

    Hi Farid,

    I'm glad that I was able to atone for that looping debacle. Thanks for the compliment and thanks for the rep!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Providing how many times staff members have been late by staff ID
    By SG56001235 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-18-2013, 10:47 PM
  2. [SOLVED] get the card# from staff ID as lookup value
    By ka_poroy in forum Excel General
    Replies: 6
    Last Post: 11-13-2013, 03:03 AM
  3. Staff Planner - How To Set Up UserForm to Generate Data into Staff & Date Spreadsheet
    By Marie Snell in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-19-2013, 11:04 PM
  4. [SOLVED] Macro to select staff list
    By Jiptastic in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-11-2013, 11:56 AM
  5. [SOLVED] how many staff have 1 skill, how many staff have 2 skills, etc.
    By ch90 in forum Excel General
    Replies: 3
    Last Post: 10-27-2005, 11:05 AM

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