Dynamic Table based on added item to a 2nd table

Perryb

New Member
Joined
Jun 27, 2011
Messages
24
Hello,
I am working in Excel 2010, and would like to find a way to dynamically Expand a table with 10 rows added for each new project added in a 2nd table. So, for example, in the 1st table below, the 1st project from Table 2 is C-1. In table 1, the 3rd and 4th column defines Diciplines and departments for 10 rows, which need to be dynamically added each time a new project is added to Table 2. So, as you can see in Table 2, the last project added is test1. I am looking to dynamically expand Table 1 to add the 10 rows for the test1 project (so there is identical entries in column 3 and 4 for each project)
ProjectDisciplineDepartment
1C-1HardwareElectrical
2C-1HardwareMechanical
3C-1
HardwarePLD
4C-1IPTPE
5C-1SoftwareSoftware
6C-1SystemsReliability
7C-1SystemsSystems Design
8C-1SystemsTest Systems
9C-1LabLab Technician
10C-1DraftingDrafting
1C295HardwareElectrical
2C295HardwarePLD
3C295IPTPE
4C295SoftwareSoftware
5C295SystemsReliability
6C295SystemsSystems Design
7C295SystemsTest Systems
8C295HardwareMechanical
9C295LabLab Technician
10C295DraftingDrafting
1C130HardwareElectrical
2C130HardwarePLD
3C130IPTPE
4C130LabLab Technician
5C130SoftwareSoftware
6C130SystemsReliability
7C130SystemsSystems Design
8C130SystemsTest Systems
9C130HardwareMechanical
10C130DraftingDrafting

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

New Programs
C-1
C295
C130
test1

<colgroup><col></colgroup><tbody>
</tbody>

Thanks
Perry
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,651
Messages
5,838,586
Members
430,557
Latest member
MK15

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top