You can use a direct reference to the workbook as the formula. The easiest
way is open the two workbooks, select the first cell on column B on the first
one, type =, change to the other workbook and select the equivalent on column
G that you want. Excel will fill the formula for you, and then you can drag
it on the column.
To make the sum, you may use something like this in column C:
=SUM(A:B)

Hope this helps,
Miguel.

"dk" wrote:

We have 2 workbooks which we want to get data from 1 to the other
ex: column a: we will manually input figures
column b: we want to get all new data when ever entered in the other
workbook in column g,
column c: shall sum the totals of column A:A -B:B
how do we do that