Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default link workbooks

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.(^_^)


 
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
How can I merge and link workbooks into one summary workbook? Sylvia Excel Worksheet Functions 3 July 31st 08 09:55 PM
how do I link cells between two different two different workbooks. Aaron The Young Excel Worksheet Functions 0 March 22nd 06 05:28 PM
Can you link many workbooks to one template? And Update? Josh M Excel Discussion (Misc queries) 0 October 18th 05 09:38 PM
Variable Link to Workbooks dfrancefort Excel Worksheet Functions 1 April 28th 05 01:15 AM
How to Link named ranges from multiple Workbooks into a single Wo. PMAP_HELP Excel Discussion (Misc queries) 1 December 14th 04 05:51 PM


All times are GMT +1. The time now is 03:24 PM.

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

About Us

"It's about Microsoft Excel"