Prev: Insert option icon
Next: copied additional column shows in view but does show on hardcopy
From: PeggyL on 1 Jun 2010 09:47
I use Microsoft Excel 2003 to track daily sales for both the my store and
employees. I also track the sales on a monthly basis and prepare an end of
the year report. I use a separate workbook for each report.

I would like to know if it is possible to link the totals from each report
into one workbook or worksheet that will automatically update when I enter
the figures. This would save me a lot of time from having to prepare each
report individually.

Thank you,
From: Luke M on 1 Jun 2010 11:43
If starting typing "=" into a cell, you can then navigate to another
sheet/open workbook and click on the cell you want to link to. This is very
useful for building summary pages.

--
Best Regards,

Luke M
"PeggyL" <PeggyL(a)discussions.microsoft.com> wrote in message
news:1CCDE7BE-129F-428D-A77E-9B53B06074BB(a)microsoft.com...
> I use Microsoft Excel 2003 to track daily sales for both the my store and
> employees. I also track the sales on a monthly basis and prepare an end of
> the year report. I use a separate workbook for each report.
>
> I would like to know if it is possible to link the totals from each report
> into one workbook or worksheet that will automatically update when I enter
> the figures. This would save me a lot of time from having to prepare each
> report individually.
>
> Thank you,


From: Tom-S on 1 Jun 2010 12:06
You can do this by making use of the INDIRECT function.

Say you have an Excel file called Book2 and in cell A1 of Sheet1 of this
file you want to 'read' what's in cell A1 of Sheet1 of another Excel file
called Book1, then in A1 of Book2 have this formula:

=INDIRECT("'[Book1.xls]Sheet1'!A1")

Note that Book1 has to be open at the same time in order for its cell
contents to be read via INDIRECT.

Hopefully, using this example you can craft the particular INDIRECT formulas
you need.

Regards,

Tom

"PeggyL" wrote:

> I use Microsoft Excel 2003 to track daily sales for both the my store and
> employees. I also track the sales on a monthly basis and prepare an end of
> the year report. I use a separate workbook for each report.
>
> I would like to know if it is possible to link the totals from each report
> into one workbook or worksheet that will automatically update when I enter
> the figures. This would save me a lot of time from having to prepare each
> report individually.
>
> Thank you,
 | 
Pages: 1
Prev: Insert option icon
Next: copied additional column shows in view but does show on hardcopy