undefined
Hi, straight to the point....
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