1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Can only add 10 Project Plans

Discussion in 'Questions about Chandoo.org Products' started by Carol Hauschild`, Sep 9, 2016.

  1. Carol Hauschild`

    Carol Hauschild` New Member

    I have reviewed the tutorial and it indicates to copy and paste the tables if you would like to add project plans. I have done this. Then is indicates to click on table and change the table name using the design tab. I have also done this. I am successful up until the 11th project plan. I can create it...however, the tasks to not show in the dashboard. There is a ref error.

    Can someone help me with this. I just purchased the product yesterday and love it so far.

    I am using the Project Portfolio dasboard VBA v1 2010
    Last edited: Sep 9, 2016
  2. NARAYANK991

    NARAYANK991 Excel Ninja

    Hi Carol ,

    Please get in touch with me , for future requests , at the following email ID :

    tech [dot] support [at] chandoo [dot] org

    Regarding this request , I will reply today. I am removing the uploaded file from your post.

  3. PMOman

    PMOman New Member

    I know who to do it, pretty simple.
    Copy the table with headings from the tables you already have with the same gap of 2 columns between. Go to the Names Manager and find a new name, should be something like plot####, and the number in the name will be more than 10. Change it by double-clicking to plot11 and save. Now go to the name lstPlans and add plot11 to the list of values.
    If you need to add more, follow one by one unless you can check the cell addresses quickly in the names.

Share This Page