Find and updata data from one sheet to another

**amarrforever** · 12-21-2009, 12:25 PM

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....

**pr4t3ek** · 12-23-2009, 12:16 AM

Hello,

Sorry i am not able to understand your query, maybe put up an example?

Thank You

**amarrforever** · 12-25-2009, 11:01 AM

Here is a sample sheet...
sorry its messed up but should give you a fair idea..

Its easy i know..but maybe not for me ;-)

**jaslake** · 12-26-2009, 02:23 AM

Hi amarrforever
I would think you may want a change event macro rather than a button. Try the attached. If you really want a button, we can make that happen.
Are these two workbooks or two worksheets in the same workbook?
John

**amarrforever** · 12-26-2009, 04:19 PM

thanks man...

I wish them to be separate workbooks stored in shared location.

**jaslake** · 12-26-2009, 04:22 PM

Hi amarrforever
What about this

you may want a change event macro rather than a button. Try the attached. If you really want a button, we can make that happen.

John

**jaslake** · 12-26-2009, 06:19 PM

Hi amarrforever
I've rewritten the code such that it works on two workbooks as you stated. The code still works on the change event principle.
I've attached two workbooks, Master and Comments. All the code exists in Master. Master has code in ThisWorkbook that opens Comments when Master is opened and it has a Before Close event that saves and closes Comments.
Master also has code in Master Sheet that is the change event code and Master has one module. I moved the Find_ID procedure to this module to take advantage of Public variables.
If you have issues, let me know.
John