How do you add cells from another workbook to a formula?

  • Thread starter Thread starter FSt1
  • Start date Start date
F

FSt1

hi
in monthly report, select g26. on the tool bar, click the sum icon. looks
like a greek sigma. toggle to weekly report. select sunday sheet. highlight
the range you want to sum in monthly report. press enter. done. toggle back
to monthy report g26.

Regards
FSt1
 
I hope that I posted this in the right group. I am trying to add data
from cells From a seperate Workbook into my current workbook. For example;
In workbook "Monthly Report" cell B3 I want to add data from Workbook "Weekly
Report 02-07-09" Tab "Sunday" Cell G26. Any idea how to do that? Thanks in
advance
 
Not exactly what I need
I am trying to add a formula to my workbook "Monthly Report" cell B3
I need the data from workbook "Weekly Report 02-07-09" Tab "Sunday" Cell G26
in Workbook "Monthly Report 02-07-09" Cell B3.
 
Open both workbooks.

In monthly report B3 type an = sign.

Switch to other workbook and Sunday sheet. select G6 and hit ENTER key


Gord Dibben MS Excel MVP
 
hi
just reversed the cell references.
in monthly report, select B3. on the tool bar, click the sum icon. looks
like a greek sigma. toggle to weekly report. select sunday sheet. select
G26 in monthly report. press enter. done. toggle back to monthy report B3.

regards
FSt1
 
Works great!!!! Thank You Very Much!!

FSt1 said:
hi
just reversed the cell references.
in monthly report, select B3. on the tool bar, click the sum icon. looks
like a greek sigma. toggle to weekly report. select sunday sheet. select
G26 in monthly report. press enter. done. toggle back to monthy report B3.

regards
FSt1
Click to expand...
 
Back
Top