LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
Posts: 1
Default VBA to linking data between two workbooks


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

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 ;)

chongchingsoo's Profile:
View this thread:

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking data within several Workbooks leerem Excel Discussion (Misc queries) 1 August 4th 08 08:39 PM
Linking data across workbooks Leonhardtk Excel Worksheet Functions 1 July 18th 07 12:50 AM
Linking text Data between 2 workbooks Speluchi Excel Discussion (Misc queries) 1 February 10th 06 02:47 PM
Linking data in different workbooks ExcelQuestion Excel Discussion (Misc queries) 0 October 18th 05 06:49 PM
linking data with other workbooks franky New Users to Excel 2 April 19th 05 11:29 PM

All times are GMT +1. The time now is 08:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"