Closed Thread
Results 1 to 11 of 11

Name Split and data on Dashboard

  1. #1
    Registered User
    Join Date
    02-09-2024
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    48

    Name Split and data on Dashboard

    Hi,

    I'm attaching an Excel file here. I just want the data to be displayed on Dashboard from Data sheet. Also, there's data on Bylines sheet, where I want values from corresponding values copied. All the queries are on the workbook. This help would mean the world to me. Thanks a lot!
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,856

    Re: Name Split and data on Dashboard

    You have several open threads - ones that have been resolved need marking as SOLVED - please go back and do this.

    Is this a tweak to a formula provided here?
    Ali


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

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    02-09-2024
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    48

    Re: Name Split and data on Dashboard

    Hi Ali,

    Before I type anything, let me go back and mark them as solved. Thanks a lot.

  4. #4
    Registered User
    Join Date
    02-09-2024
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    48

    Re: Name Split and data on Dashboard

    Hi Ali,

    All issues are marked SOLVED now. Thank you for the reiteration- one must follow the rules.


    Yes, the formula on Bylines was shared here. Thanks

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,856

    Re: Name Split and data on Dashboard

    So it would have been easier just to ask in the original thread. Which thread was it?

  6. #6
    Registered User
    Join Date
    02-09-2024
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    48

    Re: Name Split and data on Dashboard

    But there are other queries on Dashboard sheet too, that's why I thought to combine these and post as one issue. I'm learning how to act in a forum - I'll be better next time. Thanks a lot.

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,856

    Re: Name Split and data on Dashboard

    Which thread was it that you got the formula in that workbook?

  8. #8
    Registered User
    Join Date
    02-09-2024
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    48

    Re: Name Split and data on Dashboard

    The formula you have provided does copy the value of Site, Year, Month an Quarter but doesn't split the bylines with a comma in between and doesn't bring their corresponding count either.

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,856

    Re: Name Split and data on Dashboard

    Tell me the thread where you were given this formula, please.

  10. #10
    Registered User
    Join Date
    02-09-2024
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    48

    Re: Name Split and data on Dashboard

    Now that I don't remember - I think it was this:

    https://www.excelforum.com/excel-gen...ml#post5920012

  11. #11
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,856

    Re: Name Split and data on Dashboard

    Administrative Note:

    All you are asking for is a tweak to an existing formula. Therefore it does not need a new thread.

    You are allowed only ONE thread per issue here.

    Please see Forum Rule #2 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-gen...ng-values.html

    Thread closed.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Split Dashboard Data into 14 area wise
    By Pkeni7 in forum Hello..Introduce yourself
    Replies: 3
    Last Post: 12-01-2019, 05:44 PM
  2. Dashboard help! Data from columns showing in the correct boxes on dashboard
    By MattExcelLearner in forum Excel Formulas & Functions
    Replies: 35
    Last Post: 06-27-2019, 11:10 AM
  3. split column values as new wb along with 2 existing sheet (dashboard&pivot)
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2014, 05:54 AM
  4. [SOLVED] VBA to data Split from column values as new workbook save into folder with dashboard sheet
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 01-08-2014, 02:03 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