Excel - VB Code

[Dharmesh Thakkar]

Dear Friends need help for VB code
I am sending above referred file containing 500 plus records to almost 50 persons weekly for updating comments in column G and I (hatched in yellow) against each Job no (refereed Column A ) for they are responsible.

• I am sending file through mail to all 50 plus persons together
• Each responsible person filter data on their name and update comments in column G and I against each their project/s.
• Then each person send file back to me ( file/ data may be or be not be in filter mode in their name (column C) while sending it to me)
• On receipt from each person, I need to update comments (column G and I ) manually in original file from all the files received from those 50 plus persons one by one

I need help (VB code) from you

• All comments written in column “G and I” need to be copy to original file from all those 50 plus files one by ( I will open original file and then one by one those 50 plus files)
• If comment/s in cell of column G and I of original file already updated and found comments in 2^nd file then, don’t overwrite but make these cell in RED colour (so the I can re-check and kept best comment from those two )

[TABLE="class: grid, width: 800"]
<tbody>[TR]
[TD]
[TABLE="width: 642"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[TD]I
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Job No.
[/TD]
[TD]Description
[/TD]
[TD]Person Responsible
[/TD]
[TD]Client
Name
[/TD]
[TD]Total WC
[/TD]
[TD]WIP
[/TD]
[TD]Comments (WIP)
[/TD]
[TD]Debt
[/TD]
[TD]Comments (Debts)
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]50
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]100
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]250
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1000
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]