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

2. ## RE: linking 2 workbooks

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

3. ## RE: linking 2 workbooks

Don't understand
1. we will input tommorow also new data will it update automatically from 1
to second workbork
2. We don't understand were to put the = sign in each cell or the first row

"Miguel Zapico" wrote:

> 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

4. ## RE: linking 2 workbooks

1. If you have the formula, yes, it will take the value when it is updated.
2. What you need is a formula like =[Workbook Name]Sheet1!\$A\$1. I was
jumping directly to a way of doing it faster than typing, I should have write
the formula before. Just write the name of your Workbook instead of Workbook

Miguel.

"dk" wrote:

> Don't understand
> 1. we will input tommorow also new data will it update automatically from 1
> to second workbork
> 2. We don't understand were to put the = sign in each cell or the first row
>
> "Miguel Zapico" wrote:
>
> > 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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1