+ Reply to Thread
Results 1 to 7 of 7

Sheet Selection and Data Filling

  1. #1
    Forum Contributor
    Join Date
    08-12-2010
    Location
    Excel World
    MS-Off Ver
    Excel 2010 & 2007
    Posts
    210

    Exclamation Sheet Selection and Data Filling

    Hi All,

    I have a worksheet which contains many worksheets: One for the Monthly Productivity Data of the team and rest of the worksheets contain individual employees data personally.
    For Example: We have a dashboard which has all the employees performance Monthly Productivity Data, and if we move to any one of the employees worksheet; that shows his personal data/ score with ranking in each category of their group.
    Note: We have divided our team in the 3 groups: 1 for most experienced, 2 for middle and the 3rd group for the new employees or less experienced.

    This is how we would like to rank them in only their group of each category. I need your help to automatically present the data from Monthly Productivity Data to each individuals worksheet, where i can give him/her feedback(s). Number of employees is not fix in every month.

    Could you please help me out to automate my this monthly work? Please find the attached for the same.

    Thanks in advance!
    Attached Files Attached Files
    Last edited by SunOffice; 03-17-2011 at 07:10 PM.
    Excelforum is Completely Awesome! True learning with Live Examples & Best Techniques!!

  2. #2
    Forum Guru
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Sheet Selection and Data Filling

    hi, it can be done this way, please see attachment, run code "test".

    For the code to work you need to have the summary sheet of the same structure as in example being active and at least one sheet for the first person in the list being created, the code will create the others or will just update (if all sheets are there already)

    Example: the first person in the list is "Tom Cruise". Create template sheet for him (it is already created in attachment), go to the summary sheet and run the code. The missing sheets will be created by the code.
    Attached Files Attached Files
    Last edited by watersev; 03-15-2011 at 10:09 AM.

  3. #3
    Forum Contributor
    Join Date
    08-12-2010
    Location
    Excel World
    MS-Off Ver
    Excel 2010 & 2007
    Posts
    210

    Smile Re: Sheet Selection and Data Filling

    Thanks a world Mr. watersev!! I'm so thankful for ur kind efforts. Your codes are amazing, I just tried mind on them to get the final needed solution. Plz check out below codes:

    I just made a commandbutton on Monthly Productivity Data worksheet, and call your code.
    Please Login or Register  to view this content.

    Then prepared data for each employee's individual rank in the every category:

    Please Login or Register  to view this content.
    * Is there any better way or flow to generate ranking data?

    Now just added a single line in ur codes:

    Please Login or Register  to view this content.

    Kindly find the attached for better understanding , and verify the above logic flow & codes. How did u learn this way of codes writing, I would really like to learn this amazing trick.

    Could you please tell any easy way to find out a particular worksheet among N number of sheets?
    Attached Files Attached Files
    Last edited by SunOffice; 03-15-2011 at 11:39 PM.

  4. #4
    Forum Guru
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Sheet Selection and Data Filling

    hi, SunOffice, please see attachment, I've made slight changes to your rank creating code. Press the button and check result.

    Re: easy way to find out a particular worksheet among N number of sheets
    Please activate main sheet, select a cell with person's name in column A and press buttons combination:
    "ALT+right arrow",
    to move back to the main sheet being on any other sheet in the workbook:
    "ALT+left arrow".
    The main sheet must always the first, its name is not hardcoded.
    Hope this helps.

    Re: code writing
    I read VB help carefully and add some fantazy
    Last edited by watersev; 03-16-2011 at 05:17 AM.

  5. #5
    Forum Contributor
    Join Date
    08-12-2010
    Location
    Excel World
    MS-Off Ver
    Excel 2010 & 2007
    Posts
    210

    Smile Re: Sheet Selection and Data Filling

    Then New way of ranking is very smart, I had that kind of idea, but no knowledge. Thanks you've have helped me a lot!!

    Please Login or Register  to view this content.

    In ThisWorkbook:
    Please Login or Register  to view this content.
    SUPERB!! The sheet selection trick to too awesome man!! Thanks Thanks Thanks for ur wonderful help!!
    Last edited by SunOffice; 03-16-2011 at 06:18 AM.

  6. #6
    Forum Guru
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Sheet Selection and Data Filling

    if you are happy with the solution offered, please mark the thread as solved (see Forum rules for details)

  7. #7
    Forum Contributor
    Join Date
    08-12-2010
    Location
    Excel World
    MS-Off Ver
    Excel 2010 & 2007
    Posts
    210

    Smile Re: Sheet Selection and Data Filling

    Of Course I am happy with ur awesome help! Thanks a lot fren!

    I have just got something for my project:
    Please Login or Register  to view this content.

    Thanks a world for helping me! I love excelfourm!!
    Last edited by SunOffice; 03-17-2011 at 07:09 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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