Thread: link workbooks
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default link workbooks

One way is via INDEX / MATCH ..

Assuming the source table below is in sheet: A, within A1:C5

Branch Name No. of participant Instructor
Nebula 5 Ellis
Pentagon 4 Winnie
Maine 6 Kenny
Corne 7 Toby


and this table is in sheet: B, within A1:C5

Instructor Name No. of participant Fee
Toby 7 840
Kenny 6 720
Ellis 5 600
Winnie 4 480


Put in B2:
=IF(A2="","",INDEX(A!B:B,MATCH(A2,A!C:C,0)))
Copy down as far as required

(For simplicity, I assumed you mean sheets rather than books)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Syahira" wrote:
Let say I have 2 wookbooks.
WB A
Branch Name No. of participant Instructor
Nebula 5 Ellis
Pentagon 4 Winnie
Maine 6 Kenny
Corne 7 Toby

WB B
Instructor Name No. of participant Fee
Toby 7 840
Kenny 6 720
Ellis 5 600
Winnie 4 480

My questions a
1) How can I link, let say the number of participant from WB A to WB B and
make sure that it is link together with instructor name.
2) If I use to just type"=" in WB B in number of participants colunm and
link it to WB A in the same column, when I sort out WB A, it get totally
wrong, how can I fix this?

Thank you for helping me.(^_^)