+ Reply to Thread
Results 1 to 4 of 4

Predicting the complexity of a project based on a set of rules- Power Query/VBA/Macro

  1. #1
    Forum Contributor
    Join Date
    10-18-2016
    Location
    Chicago, USA
    MS-Off Ver
    Office 365
    Posts
    180

    Red face Predicting the complexity of a project based on a set of rules- Power Query/VBA/Macro

    Hi All,

    Hope you are doing well!...I am trying to predict the complexity of a project based on a set of questions (with each question having a drop down of anwers)-Column C(Please input your understanding) has the list of option to be chosen for each question..Based on the value chosen -the value to be assigned it can be taken from the Column E (notes column) and the value taken from the column E should be multiplied with value from Column D and finally all the values should be added to get the final score based on which the recommendation should pop up as a dialog box based on the guildelines on the output sheet in the second tab ...The recommendation should come up as a dialog box on the input sheet after the user has clicked through all the options in the input sheet...
    Can you please help me here...Attached the file!


    Thanks,
    Arun
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    1,701

    Re: Predicting the complexity of a project based on a set of rules- Power Query/VBA/Macro

    I added a few columns to your sheet and hid them so it looks the same. When you make the last entry at C9, the Output sheet will open with a popup of the complexity value.

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    10-18-2016
    Location
    Chicago, USA
    MS-Off Ver
    Office 365
    Posts
    180

    Re: Predicting the complexity of a project based on a set of rules- Power Query/VBA/Macro

    Hi Maniacb,

    Appreciate your response!.. I am getting saying that "Unable to get the sumproduct property of the Worksheetfunction class"

    Thanks,
    Arun

  4. #4
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    1,701

    Re: Predicting the complexity of a project based on a set of rules- Power Query/VBA/Macro

    Replace the code in the Input sheet module with the following:

    Please Login or Register  to view this content.

+ 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. Migrate VBA Power Query project
    By aldenes in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-31-2021, 10:22 AM
  2. Replies: 10
    Last Post: 06-25-2020, 12:19 AM
  3. Replies: 4
    Last Post: 02-17-2020, 06:03 AM
  4. Power Query: Updating a query based on changing tables
    By cheesehead101 in forum Excel General
    Replies: 1
    Last Post: 12-16-2019, 06:54 PM
  5. VBA/ Power Query project - blueprint or strategy needed
    By foxtrotter in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-18-2019, 05:58 PM
  6. Predicting/Regression Calculation For Server Utilization Power/CPU/Mem
    By brafter70 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-20-2019, 04:14 PM
  7. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 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