Pulling cell information from one workbook to another
 

My questions is this:

How will I be able to have information pull from one cell in one workbook to
another cell in another workbook? I can easily do it when they are on the
same workbook but different sheets, but how is this possible to have it
automatically pull the information from another workbook into the other
workbook?

example (I know it sounds confusing-sorry)

Workbook 1 (Warehouse 1)
Sheet 1 (Paper)
A B C
1 amount received amount instock total inv.
2 50 25 =sum(A2:B2) 75

3 30 40 =sum(A3:B3) 70
4 =sum(A2:A3) 80 =sum(B2:B3) 65 =sum(A4:B4) 145

Workbook 1 (Warehouse 2)
Sheet 1 (Paper)
A B C
1 amount received amount instock total inv.
2 60 50 =(sumA2:B2) 110

3 50 50 =(sumA3:B3) 100
4 =sum(A2:A3) 110 =sum(B2:B3) 100 =sum(A4:B4) 145
Now let' say I wanted to start a new workbook and pull the numbers from both
workbooks C4 into the new work book, how would I make this happen? I can
already do it when the sheets are in the same work book, but I have failed in
trying to pull numbers from certain cells in different worksbooks together.

Can you give me a direct route into completeing this?

Pulling cell information from one workbook to another
 

Try this.
Open two new workbooks; say Book1 and Book2
In A1 of Book2 etner a number, say 99
Go to Book1; type =; open Book2; click on A1; press the Enter key or click
the checkmark on Formula Bar
Look at formula in Book1; it will be =[Book2]Sheet1!$A$1
You could type the formula but the pointing method works best because when
the book name or sheet name have spaces in them the formula need single
quotes as in ='[Expt book.xlsx]Sheet1'!$A$1
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Quinci" wrote in message
...
My questions is this:

How will I be able to have information pull from one cell in one workbook
to
another cell in another workbook? I can easily do it when they are on the
same workbook but different sheets, but how is this possible to have it
automatically pull the information from another workbook into the other
workbook?

example (I know it sounds confusing-sorry)

Workbook 1 (Warehouse 1)
Sheet 1 (Paper)
A B C
1 amount received amount instock total inv.
2 50 25 =sum(A2:B2)
75

3 30 40 =sum(A3:B3)
70
4 =sum(A2:A3) 80 =sum(B2:B3) 65 =sum(A4:B4) 145

Workbook 1 (Warehouse 2)
Sheet 1 (Paper)
A B C
1 amount received amount instock total inv.
2 60 50 =(sumA2:B2)
110

3 50 50 =(sumA3:B3)
100
4 =sum(A2:A3) 110 =sum(B2:B3) 100 =sum(A4:B4) 145
Now let' say I wanted to start a new workbook and pull the numbers from
both
workbooks C4 into the new work book, how would I make this happen? I can
already do it when the sheets are in the same work book, but I have failed
in
trying to pull numbers from certain cells in different worksbooks
together.

Can you give me a direct route into completeing this?

Pulling cell information from one workbook to another
 

I was using XL2007 as the example. Replace XLSX by XLS for earlier versions
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Quinci" wrote in message
...
My questions is this:

How will I be able to have information pull from one cell in one workbook
to
another cell in another workbook? I can easily do it when they are on the
same workbook but different sheets, but how is this possible to have it
automatically pull the information from another workbook into the other
workbook?

example (I know it sounds confusing-sorry)

Workbook 1 (Warehouse 1)
Sheet 1 (Paper)
A B C
1 amount received amount instock total inv.
2 50 25 =sum(A2:B2)
75

3 30 40 =sum(A3:B3)
70
4 =sum(A2:A3) 80 =sum(B2:B3) 65 =sum(A4:B4) 145

Workbook 1 (Warehouse 2)
Sheet 1 (Paper)
A B C
1 amount received amount instock total inv.
2 60 50 =(sumA2:B2)
110

3 50 50 =(sumA3:B3)
100
4 =sum(A2:A3) 110 =sum(B2:B3) 100 =sum(A4:B4) 145
Now let' say I wanted to start a new workbook and pull the numbers from
both
workbooks C4 into the new work book, how would I make this happen? I can
already do it when the sheets are in the same work book, but I have failed
in
trying to pull numbers from certain cells in different worksbooks
together.

Can you give me a direct route into completeing this?

Pulling cell information from one workbook to another
 

Bernard Thanks,

This was very simple. I'm working on a major database that I have to pull
information from all over different workbooks and have them coincide with one
another. This was truly helpful.

"Quinci" wrote:

My questions is this:

How will I be able to have information pull from one cell in one workbook to
another cell in another workbook? I can easily do it when they are on the
same workbook but different sheets, but how is this possible to have it
automatically pull the information from another workbook into the other
workbook?

example (I know it sounds confusing-sorry)

Workbook 1 (Warehouse 1)
Sheet 1 (Paper)
A B C
1 amount received amount instock total inv.
2 50 25 =sum(A2:B2) 75

3 30 40 =sum(A3:B3) 70
4 =sum(A2:A3) 80 =sum(B2:B3) 65 =sum(A4:B4) 145

Workbook 1 (Warehouse 2)
Sheet 1 (Paper)
A B C
1 amount received amount instock total inv.
2 60 50 =(sumA2:B2) 110

3 50 50 =(sumA3:B3) 100
4 =sum(A2:A3) 110 =sum(B2:B3) 100 =sum(A4:B4) 145
Now let' say I wanted to start a new workbook and pull the numbers from both
workbooks C4 into the new work book, how would I make this happen? I can
already do it when the sheets are in the same work book, but I have failed in
trying to pull numbers from certain cells in different worksbooks together.

Can you give me a direct route into completeing this?