Results 1 to 31 of 31

Update Dasboard using VBA.

Threaded View

  1. #1
    Registered User
    Join Date
    04-13-2013
    Location
    UK
    MS-Off Ver
    Excel 2007 / Excel 2010
    Posts
    51

    Update Dasboard using VBA.

    Jason says a very humble hello to all. This is my first ever post on this forum and the very first assignment I got in my new job!

    I’ve been given a responsibility to develop a report that will be used daily by the management. I was hoping to get some VBA help to be able to automatically generate it.

    I use formulas like sumif, sumifs, count, vlookup etc but it is taking considerably long due to a major challenge that the names in the 3-4 sources are not very much aligned and or there are multiple ways in which the name is available but that needs to be aligned to a unique one. Thusfar I’ve worked and created a Related name sheet (last tab of the sample attached) that is to be the basis and use formulas which chucks of lot of my time

    My request explanation is available in Tab 1 while the Dashboard I wanted to update along with the expected result in Tab 2. The other data sources are also in Tab 3, 4 & 5.

    Could any of the esteemed experts assist me on this please…

    Please forgive me in case I do anything which isn’t correct.

    Warmest regards,
    Jason (aka avid2xl)
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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