Is there a way to create multiple tasks with the same subtasks without copy and paste?

Posted on 2011-10-07
Last Modified: 2012-05-12
Let's say you had tasks for hardware to be installed in all 50 states.
For each state, you have five sub-tasks.
  Order hardware for state
  Arrange for receipt and installation of hardware
  Install hardware
  Test hardware
  Implement use of hardware
  same steps
  same steps
Is there a way to create multiple tasks with the same subtasks without copy and paste?
I am thinking there is some way to export to Excel, add the subtasks and then import back in.

Question by:Alex972
    LVL 18

    Expert Comment

    by:Richard Daneke
    Macros can be setup in project to do this.

    Author Comment

    I'm not proficient in VB macros so I am looking for some way to export to Excel and then import back into Project.
    LVL 29

    Accepted Solution

    haven't used project but you can sure;y export as excel and from there I can create a module for you and then you should see if you can import from excel to project I guess if u can export then you can import it should be same format.

    Author Closing Comment

    Tried solution and it worked.  Thanks!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
    This article will show you how to use shortcut menus in the Access run-time environment.
    This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now