Viewing Excel Documents without Opening

  • Thread starter Thread starter Clayton
  • Start date Start date
C

Clayton

Hi,
I have about 60 individual excel documents which are invoices.
I have created a template with the customers name, address, date, invoice
number, quantity, totals and all that jazz that goes along with the invoice.
My question is, is there a way to view at least the date, subtotals, GST and
totals in one spreadsheet instead of opening them all.

Thanks
 
Hi
you can link them to one mastersheet. simply enter the equation sign
'=' and locate the source cells. After this your master file should
collect all data
 
Try this small test:

Create a new workbook (File|New)
Open one of your workbooks.

In A1 of Sheet1 of the new workbook, type the equal sign.

Then click on Window and select the test workbook.

Point at one of your cells on a worksheet and hit enter.

You'll see something like:

=[book1.xls]Sheet1!$A$1

Now if you close that test workbook, you'll see your formula adjust to:
='C:\My Documents\excel\[book1.xls]Sheet1'!$A$1
(It now includes the whole drive/path/workbook name/worksheet name and address)

Now save this new workbook (and close it).

Open that same test workbook once more. Make a change and save it, then close
it.

Now back and open your newly created "mastersheet" workbook.

You'll be prompted to find out if you want to update your links (if you haven't
turned that off).

If you answer yes, excel will go off to that other workbook and retrieve a fresh
value.

=====
Another way to build the formula is through typing (yech!) or by opening your
workbook, then selecting a cell and copying it.

Then back to that mastersheet workbook and edit|Paste special|paste link.
 
Back
Top