Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I merge and link workbooks into one summary workbook? | Excel Worksheet Functions | |||
how do I link cells between two different two different workbooks. | Excel Worksheet Functions | |||
Can you link many workbooks to one template? And Update? | Excel Discussion (Misc queries) | |||
Variable Link to Workbooks | Excel Worksheet Functions | |||
How to Link named ranges from multiple Workbooks into a single Wo. | Excel Discussion (Misc queries) |