Reference Page

Anthony G. · May 15th, 2002, 03:14 PM

Hello to all!! I have a standard subtotaled report with a Grand Total, with , let's say 25 subtotals in all. The report well exceeds 350 pages and I would like to know if there is a way to create a reference page containing the subtotal description, specific subtotal amount and its appropriate page numbers.

The report contains 10 columns of data and I would only like to identify the following columns:
I J
California Total $100,000 Pages 1-49
Indiana Total $35,000 Pages 49-62
Grand Total $3,500,000 Page 350

Is this possible?

Thank You,

Anthony

Brian · May 16th, 2002, 01:21 AM

You could use a vlookup statement.

something like:

=VLOOKUP("California Total",DataSheet!1:65536,9,0)

Assuming "California Total" is in col A (ie. 1)
Assuming $ to toatal is in row I (ie col 9 of selected range 1:65536 on sheet "DataSheet")

Better to use a named range that contains only your table, but if that changes size and you do not repeat the words "California total" in col A, the the above will work fine.

Anthony G. · May 16th, 2002, 07:32 AM

Thanks Brian......I'll give it a try!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 15th, 2002, 03:14 PM	#1
Anthony G. Board Regular Join Date: Mar 2002 Posts: 465	Hello to all!! I have a standard subtotaled report with a Grand Total, with , let's say 25 subtotals in all. The report well exceeds 350 pages and I would like to know if there is a way to create a reference page containing the subtotal description, specific subtotal amount and its appropriate page numbers. The report contains 10 columns of data and I would only like to identify the following columns: I J California Total $100,000 Pages 1-49 Indiana Total $35,000 Pages 49-62 Grand Total $3,500,000 Page 350 Is this possible? Thank You, Anthony

May 16th, 2002, 01:21 AM	#2
Brian Board Regular Join Date: Apr 2002 Posts: 113	You could use a vlookup statement. something like: =VLOOKUP("California Total",DataSheet!1:65536,9,0) Assuming "California Total" is in col A (ie. 1) Assuming $ to toatal is in row I (ie col 9 of selected range 1:65536 on sheet "DataSheet") Better to use a named range that contains only your table, but if that changes size and you do not repeat the words "California total" in col A, the the above will work fine.

May 16th, 2002, 07:32 AM	#3
Anthony G. Board Regular Join Date: Mar 2002 Posts: 465	Thanks Brian......I'll give it a try!