Find, Copy, Paste to different workbook VBA

[excelforum334234]

WorkbookA is my working workbook. WorkbookB is kind of like my database.

I would like to:

FIND

data from WorkbookA/SheetA/ColumnC in WorkbookB/SheetA/ColumnA

THEN

copy corresponding WorkbookB/SheetA/ColumnB data (may contain image and text in the same cell) to paste to WorkbookA/SheetA/ColumnD

DO THIS

whenever WorkbookA/SheetA/ColumnC has data

Any help from Excel Masters would be appreciated.

[abdul.wasie]

check this link.
http://www.youtube.com/watch?v=CEM0pp5SjMU

let me know it helps.