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