Hey everyone...I will try to keep this post short.
Here are the steps the process that I need Excel to do...
1. Data comes in (put in "Data" Sheet)
2. Data is then calculated on ETC sheet
3. Salesmen input comment on these calculations on the ETC sheet
4. New data comes in
5. New data in copy/pasted over "Data" sheet
6. New data is calculated in the ETC sheet
7. Salesmen input their comments in the updated ETC sheet and can also change their previous comments

I need a Macro that can:

1.Get New data pasted in to Data sheet
2. macro looks at each new item to see if it exists on the ETC sheet.
a. add necessary formula row to etc sheet
b. add the needed columns from data to etc (determine where each source column goes on each destination column)
c. sort by col A as shown here
AD3W08
AD3W09
AD3W011
AD3W041
Calculates and places the NEW data