+ Reply to Thread
Results 1 to 10 of 10

Need VBA to fill unique values to row and column like dashboard table

  1. #1
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Need VBA to fill unique values to row and column like dashboard table

    HI experts

    I have set of rawdata, which need to set up like dashboard table i want fill unique values across row and column from column

    Table-1
    In Column BM:BM, have week no i want unique value fill across row from B18
    In Column O:O have Issuances i want unique value fill in column from A19

    After 5 row copy and paste same table as Table-2
    In Column BM:BM, have week no i want unique value fill across row from B cell after 5 row
    In Column O:O have Issuances i want unique value fill in column from A cell after 5 row

    after 2 table i want big table across row and table

    In Column BM:BM, have week no i want unique value fill across row from B
    In Column O:O have Issuances i want unique value fill in column from A
    In column P:P have Sub Issuances Code i want unique under issuance value

    After 5 row copy and paste same table as Table-2
    In Column BM:BM, have week no i want unique value fill across row from B
    In Column O:O have Issuances i want unique value fill in column from A
    In column P:P have Sub Issuances Code i want unique under issuance value

    find the attachment
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    27,999

    Re: Need VBA to fill unique values to row and column like dashboard table

    Why is "VTT ..." excluded ?
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: Need VBA to fill unique values to row and column like dashboard table

    Yes I want exclude for seperation sorry, i forgot it to mentiion in requirement. if add in code help me, otherwise i do it manually

  4. #4
    Forum Contributor
    Join Date
    11-23-2022
    Location
    Amsterdam
    MS-Off Ver
    2021
    Posts
    193

    Re: Need VBA to fill unique values to row and column like dashboard table

    Sorry but it's not clear which values have to be put in these tables. Has table 1 to be filled with the total number of issuances, and table 3 with the number of networkdays? Is table 2 an exact copy of table 1, and table 4 an exact copy of table 3?

  5. #5
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: Need VBA to fill unique values to row and column like dashboard table

    No values in Table simple table reference header values in row and column ,if i add more values in Week and issuance & sub issuance according to more values need uniue values in row and column. simple blank table

  6. #6
    Forum Contributor
    Join Date
    11-23-2022
    Location
    Amsterdam
    MS-Off Ver
    2021
    Posts
    193

    Re: Need VBA to fill unique values to row and column like dashboard table

    Could you post your excel file with the tables filled, at least for one cell?

  7. #7
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    27,999

    Re: Need VBA to fill unique values to row and column like dashboard table

    See attached Sheet1.

    If this is what is required I will post code.
    Attached Files Attached Files

  8. #8
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: Need VBA to fill unique values to row and column like dashboard table

    HI boss its work except the WK nos not fill across row in table1 and table 2 field

  9. #9
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    27,999

    Re: Need VBA to fill unique values to row and column like dashboard table

    See attached
    Attached Files Attached Files

  10. #10
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: Need VBA to fill unique values to row and column like dashboard table

    Thanks boss It works solved Great honor to your experties

+ 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. Excel formula to fill column B with unique values from column A
    By CV_Sam in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 01-24-2022, 09:29 AM
  2. [SOLVED] fill blank cells in a column by duplicating values of first unique instance
    By hasan mougharbel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-11-2021, 03:46 AM
  3. [SOLVED] Finding array of values unique to one table column compared to another table column
    By TimRC in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-23-2021, 10:16 PM
  4. Index & Match - fill table with unique values
    By Confuselocated in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-17-2020, 09:45 AM
  5. List unique column values from table in new table
    By PeterBSR in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-25-2018, 09:39 AM
  6. Fill Column B based on non-unique values in Column A
    By viksmehta in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-21-2014, 07:39 AM
  7. Look up values in from one table and fill in a column on another table with corresponding
    By Courtland Clarkson in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-06-2013, 12:18 PM

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