Closed Thread
Results 1 to 8 of 8

Automatically populate a 9 box grid using excel data

  1. #1
    Registered User
    Join Date
    02-05-2014
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2010
    Posts
    7

    Automatically populate a 9 box grid using excel data

    Hi,

    I'd like to automatically populate a 9 box grid using data from Excel. The number of names for each rating can be anything from 1 to 100 so the size of the grid would need to be adjustable. I would like one table for each function and grade. Attached is what I'm trying to do, can anyone help? In the 'example tables' sheet, I've shown how I'd like the tables to look, but with my live data the tables would be bigger so I'd like to do one table per worksheet (or possibly one function per worksheet - so 3 tables).

    I hope this makes sense!

    Thanks
    Chris
    Attached Files Attached Files

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,135

    Re: Automatically populate a 9 box grid using excel data

    Hi,

    Please see if you are Ok doing this with the help of a Pivot Table (file attached).
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    02-05-2014
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Automatically populate a 9 box grid using excel data

    Hi,

    Thanks for the reply. I am using pivots at the moment but having to copy the information so it appears in the 9 box grid format.

    Thanks
    Chris

  4. #4
    Registered User
    Join Date
    02-05-2014
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Automatically populate a 9 box grid using excel data

    Sorry I just realised I uploaded my file before I had finished updating it. Please see updated attachment with the tables how I'd like them to be displayed.


    Thanks
    Chris
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    07-05-2017
    Location
    Houston
    MS-Off Ver
    don't know
    Posts
    2

    Re: Automatically populate a 9 box grid using excel data

    In this worksheet, what does the calibration 1-5 column mean?

  6. #6
    Registered User
    Join Date
    05-25-2022
    Location
    Utah, United States
    MS-Off Ver
    365
    Posts
    2

    Re: Automatically populate a 9 box grid using excel data

    I am a new uses and not an expert in Excel. I am trying to create a simple HR 9 box. it will be about 400 employees so i want to categorize them by job title , perf and potential

  7. #7
    Registered User
    Join Date
    05-25-2022
    Location
    Utah, United States
    MS-Off Ver
    365
    Posts
    2

    Re: Automatically populate a 9 box grid using excel data

    Would love some help with a template that would just allow me to enter the names and populate a 9 box for HR. I am good but not an expert with excel formulas. I have a lot of employees and want to categorize by job title, perf, potential

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,648

    Re: Automatically populate a 9 box grid using excel data

    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how can i automatically populate data in excel
    By Thinker8 in forum Excel General
    Replies: 3
    Last Post: 10-14-2013, 09:07 PM
  2. VBA to automatically populate Excel calendar with staff vacation (leave) data
    By batteredveg in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-21-2013, 04:09 PM
  3. Auto-populate composite grid
    By ryancaseymcshane in forum Excel General
    Replies: 0
    Last Post: 03-08-2013, 05:45 PM
  4. Replies: 3
    Last Post: 03-18-2011, 12:37 AM
  5. Auto-populate Grid
    By COMTEC in forum Excel General
    Replies: 1
    Last Post: 11-15-2010, 01:19 PM

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