<div>
Macros can be setup in project to do this.
</div>


Macros can be setup in project to do this.

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


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

<div>
Tried solution and it worked. &nbsp;Thanks!
</div>


<div>
<div class="content wysiwyg-content">
Let's say you had tasks for hardware to be installed in all 50 states.<br />
For each state, you have five sub-tasks.<br />
Alabama<br />
&nbsp; Order hardware for state<br />
&nbsp; Arrange for receipt and installation of hardware<br />
&nbsp; Install hardware<br />
&nbsp; Test hardware<br />
&nbsp; Implement use of hardware<br />
Alaska<br />
&nbsp; same steps<br />
Arizona<br />
&nbsp; same steps<br />
Is there a way to create multiple tasks with the same subtasks without copy and paste?<br />
I am thinking there is some way to export to Excel, add the subtasks and then import back in.<br />
<br />

</div>
</div>


Let's say you had tasks for hardware to be installed in all 50 states.
For each state, you have five sub-tasks.
Alabama
  Order hardware for state
  Arrange for receipt and installation of hardware
  Install hardware
  Test hardware
  Implement use of hardware
Alaska
  same steps
Arizona
  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.



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

Project management software has the capacity to help plan, organize, and manage resource tools and develop resource estimates. Depending on the sophistication of the software, it can manage estimation and planning, scheduling, cost control and budget management, resource allocation, collaboration software, communication, decision-making, quality management and documentation or administration systems.

Project Management Software

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.