Automatically Extract Data from Table and Input to Data Table Suitable for Pivot Table

[theteerex]

Hi All,

I am trying to link two tables such that inputs to one automatically creates a new set of data in another.
I have a Project table that contains a list of projects and their data. The table is arranged in such a way that each project is one row.
I also have a Data table that feeds a pivot table used to analyze the project data.

What I have done so far:

1. I have created a Master table within the Data table.
2. I have created a button that automatically copies this Master table and pastes it in the first empty row in the Data table.
3. The user then changes the name of the project so that the Data table knows to go to the Project table and pulls the correct information into the Data table.

Is there a way to automate these tasks in the following way

1. Once a user inputs information in the Project table, it is automatically detected by the Data table?
2. Once it is detected, the Data table creates a copy of the Master table and then;
3. Inputs the correct information, based on the new entry in the Project table?

I am basically using the Master table as a template so users do not mess up formatting, making the Data table useful for pivot analysis.

Please let me know if I haven't explained anything clearly.
Thank you for your help.

 

[theteerex]

To be more descriptive, I start with projects in a row on another sheet.
[TABLE="width: 3271"]
<tbody>[TR]
[TD]Proposal[/TD]
[TD]Type[/TD]
[TD]Project_No[/TD]
[TD]DeliveryCountry[/TD]
[TD]FabricatorCountry[/TD]
[TD]Column1[/TD]
[TD]Unit Type[/TD]
[TD]Size[/TD]
[TD]Units[/TD]
[TD]SoldDate[/TD]
[TD]Quarter[/TD]
[TD]Year[/TD]
[TD]Status[/TD]
[TD]DetailDesigner[/TD]
[TD]Fabricator[/TD]
[TD]01_Fabrication[/TD]
[TD]01_FabCon[/TD]
[TD]02_Detail Design[/TD]
[TD]02_DDCon[/TD]
[TD]03_Shipping_duties[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Moneypit[/TD]
[TD]Project[/TD]
[TD="align: right"]1234567[/TD]
[TD]ME & Africa[/TD]
[TD]S. Korea[/TD]
[TD][/TD]
[TD]ISOM[/TD]
[TD="align: right"]700[/TD]
[TD]BPSD[/TD]
[TD="align: right"]4/13/2015[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2015[/TD]
[TD]Sold[/TD]
[TD]ABC[/TD]
[TD]XYZ[/TD]
[TD] $ 6,485,869.94[/TD]
[TD][/TD]
[TD] $ 827,485.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I then transfer useful data to another worksheet in the format below so they can be analyzed with a pivot table.
Is there a way for me to have the data automatically be pulled in and follow the rules I have in place?

[TABLE="width: 2854"]
<tbody>[TR]
[TD="align: left"]

Project

<tbody>
</tbody>

[/TD]
[TD]Type[/TD]
[TD]ProjectNumber[/TD]
[TD]DeliveryCountry[/TD]
[TD]FabricatorCountry[/TD]
[TD]Unit Type[/TD]
[TD]Size[/TD]
[TD]Units[/TD]
[TD]SoldDate[/TD]
[TD]Parameter[/TD]
[TD]Quarter[/TD]
[TD]Year[/TD]
[TD]Status[/TD]
[TD]DetailDesigner[/TD]
[TD]Fabricator[/TD]
[TD]Category[/TD]
[TD]Value[/TD]
[/TR]
[TR]
[TD]Moneypit[/TD]
[TD]Project[/TD]
[TD]1234567[/TD]
[TD]ME & Africa[/TD]
[TD]S. Korea[/TD]
[TD]ISOM[/TD]
[TD="align: right"]700[/TD]
[TD]BPSD[/TD]
[TD="align: right"]42107[/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2015[/TD]
[TD]Sold[/TD]
[TD]ABC[/TD]
[TD]XYZ[/TD]
[TD]01_Fabrication[/TD]
[TD="align: right"]6485869.94[/TD]
[/TR]
[TR]
[TD]Moneypit[/TD]
[TD]Project[/TD]
[TD]1234567[/TD]
[TD]ME & Africa[/TD]
[TD]S. Korea[/TD]
[TD]ISOM[/TD]
[TD="align: right"]700[/TD]
[TD]BPSD[/TD]
[TD="align: right"]42107[/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2015[/TD]
[TD]Sold[/TD]
[TD]ABC[/TD]
[TD]XYZ[/TD]
[TD]01_FabCon[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Moneypit[/TD]
[TD]Project[/TD]
[TD]1234567[/TD]
[TD]ME & Africa[/TD]
[TD]S. Korea[/TD]
[TD]ISOM[/TD]
[TD="align: right"]700[/TD]
[TD]BPSD[/TD]
[TD="align: right"]42107[/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2015[/TD]
[TD]Sold[/TD]
[TD]ABC[/TD]
[TD]XYZ[/TD]
[TD]02_Detail Design[/TD]
[TD="align: right"]827485[/TD]
[/TR]
[TR]
[TD]Moneypit[/TD]
[TD]Project[/TD]
[TD]1234567[/TD]
[TD]ME & Africa[/TD]
[TD]S. Korea[/TD]
[TD]ISOM[/TD]
[TD="align: right"]700[/TD]
[TD]BPSD[/TD]
[TD="align: right"]42107[/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2015[/TD]
[TD]Sold[/TD]
[TD]ABC[/TD]
[TD]XYZ[/TD]
[TD]02_DDCon[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Moneypit[/TD]
[TD]Project[/TD]
[TD]1234567[/TD]
[TD]ME & Africa[/TD]
[TD]S. Korea[/TD]
[TD]ISOM[/TD]
[TD="align: right"]700[/TD]
[TD]BPSD[/TD]
[TD="align: right"]42107[/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2015[/TD]
[TD]Sold[/TD]
[TD]ABC[/TD]
[TD]XYZ[/TD]
[TD]03_Shipping_duties[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]