Advanced Sorting Macro

[ZackG]

Hey everyone,

Help would be much appreciated!

I am looking for a macro that "sticks" a column of comments section to their ID sales number. Every month, Sales Reps add comments to an excel spreadsheet. When the month is over, more ID sales numbers are pasted into this spreadsheet. This is where the problem occurs. The comments stay in their place, while the ID Sales numbers are moved around, since more are added (and the ID #s are sorted alphabetically.) Basically, I am trying to give the "Comments" column the ability to "stick" to their own unique ID sales number.

Here is the exact process that takes place:

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 give an explanation as well in the excel attachment.

Thanks in advance for all the help!!!!