VBA to linking data between two workbooks
 

undefined

Hi, straight to the point.... :cool:

Workbook 1
Column A = Date
Column B = Number
Column C= Detail
Column D = Balance

E.g.: Column A1= 1/1/2004, Column B1=199, Column C=EARTH, Column D
$5.00

Workbook 2
Column E = Date
Column H= Detail
Column L = Balance (figure)
Column M = Balance (text)

I would like to know whether VBA can do the following:-

1) Create a list box in workbook 2 linking data ONLY to Column B i
Workbook 1.

2) For example, if I click in the list box of Workbook 2 for *199*
then _1/1/2004_, _EARTH_ and _$5.00___ will automatically appear in th
Column E, Column H, Column L and Column M of Workbook 2.

Please advice.

Thank u.

Susan ;)


--
chongchingso
-----------------------------------------------------------------------
chongchingsoo's Profile: http://www.excelforum.com/member.php...fo&userid=1633
View this thread: http://www.excelforum.com/showthread.php?threadid=27772