Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Linking data within several Workbooks | Excel Discussion (Misc queries) | |||
Linking data across workbooks | Excel Worksheet Functions | |||
Linking text Data between 2 workbooks | Excel Discussion (Misc queries) | |||
Linking data in different workbooks | Excel Discussion (Misc queries) | |||
linking data with other workbooks | New Users to Excel |