Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link with workbook in other folder which is in another group
I want put the data from cell in other workbook of folder in other group say
Engineering, while our folder is in accounting group. Is it possible? Frank |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link with workbook in other folder which is in another group
As long as people opening the workbooks have the priveleges to access both
directories then this will work OK. Mike "Frank Situmorang" wrote: I want put the data from cell in other workbook of folder in other group say Engineering, while our folder is in accounting group. Is it possible? Frank |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link with workbook in other folder which is in another group
First open both workbooks in one instance of Excel. Copy the values from the
first worksbook and then either paste or paste/special/link into the second workbook. -- Gary''s Student - gsnu200713 "Frank Situmorang" wrote: I want put the data from cell in other workbook of folder in other group say Engineering, while our folder is in accounting group. Is it possible? Frank |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link with workbook in other folder which is in another group
Thanks Gary, it gives me more insights, but could you exlain more, if I want
an automatic upddate. What I meant is that an amount in a cell depending on the total amount in another worksheet which is in another folder of different group,which workbook is done by Revenue section for example. Thank you, Frank Jakarta, Indonesia "Gary''s Student" wrote: First open both workbooks in one instance of Excel. Copy the values from the first worksbook and then either paste or paste/special/link into the second workbook. -- Gary''s Student - gsnu200713 "Frank Situmorang" wrote: I want put the data from cell in other workbook of folder in other group say Engineering, while our folder is in accounting group. Is it possible? Frank |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
link to files in this folder | Excel Discussion (Misc queries) | |||
How do I link a folder to a cell in an Excel spreadsheet | Excel Worksheet Functions | |||
How do I link an Excel worksheet to a folder? | Excel Discussion (Misc queries) | |||
Opening a folder by clicking on a link | Excel Discussion (Misc queries) | |||
How do I link a FOLDER to an excel cell/row? | Excel Discussion (Misc queries) |