Instructions
Enter the required invoice numbers on the Summary sheet
If you need more rows, copy down the bottom row to preserve formatting
When you are ready, hit the 'Fill References' button
If you move things around you will have to change the settings on the Control tab
When you open the workbook you get a message asking you if you want to update links. SELECT CONTINUE
ELECT CONTINUE
Control
v20091129-0
Input values Notes
Control values (rarely need to change these)
Sheet name in remote sheet sheet1 Name: sheetName
First row to fill 7 Name: FirstRow
Row containing remote refs. 1 Name: RefRow
Column containing file names 2 Name: FnameCol - note this must be the number of the column, no
Name of summary sheet Summary Name: SummaryName
Invoice filename format 00
Maximum number of columns 200 Name: MaxCol
Maximum number of rows 8000 Name: MaxRow
Linked file extension .xls .xls or .xlsx
Derived values (do not touch these)
Path to this sheet C:\Docstoc\Working\pdf\[421ebec3-bd45-4054-9583-8a764cb5cd72.xls]Summary
Path to this file Name: FilePath
C:\Docstoc\Working\pdf\
st be the number of the column, not a letter
Remote cell references >>> F36 F36 F36 F36
Invoice Summary for 2009 (raw lookup)
Inv. No. Filename Ref. Customer Net Vat
1 01.xls
2 02.xls
3 03.xls
4 04.xls
5 05.xls
6 06.xls
7 07.xls
8 08.xls
9 09.xls
10 10.xls
11 11.xls
12 12.xls
13 13.xls
14 14.xls
15 15.xls
16 16.xls
17 17.xls
18 18.xls
19 19.xls
20 20.xls
F36
Invoice Summary for 2009 (with tests for missing files so totals work)
Total Ref. Customer Net Vat
0 0 - -
0 0 - -
0 0 - -
0 0 - -
0 0 - -
0 0 - -
0 0 - -
Subtotal - -
0 0 - -
0 0 - -
0 0 - -
0 0 - -
0 0 - -
0 0 - -
0 0 - -
0 0 - -
0 0 - -
0 0 - -
0 0 - -
0 0 - -
0 0 - -
Subtotal - -
Total - -
ests for missing files so totals work)
Total
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-