Hi guys,

I have two workbooks.

Basically, one workbook contains a comment generator and other contains unique ID against which I need to update that comment.

How do I do this with just one click of a buton??

Workbook 1

Comment : ASDFGH DSFSD ASDSD on 12/13/009

Workbook 2

Unique ID Client Name Client ADD Contact Comment
123 abc --- 4568 ASDFGH DSFSD ASDSD on..


What I wish to achive is that when i press a button on workbook 1, it should find that unique ID in 2nd workbook and update the comment against that.


Please help....