Capturing info on multiply pages - Linking

  • Thread starter Thread starter Judy J
  • Start date Start date
J

Judy J

I don't know how to word this well

Is there a way to link data and create a chart
if the data occurs every month in the same cells on an
excel spreadsheet in a monthly report and each monthly
report is complied as an individule spreadsheet in the
same workbook?

Example
Workbook has 12 spreadsheets each one labled for a month
Jan, Feb, March etc

On each spread sheet in column A line 2 is
Jan. Total Usage or
Feb. Total Usage etc

and Column B line 2 is the numeraic amount:
142,685
154,955

Is there a way to link those monthly reports and capture
the info to reflect on a chart?
 
Judy -

Put the workbook names in A2:A13 of a summary sheet. Put A2 in cell B1
and B2 in cell C1 of the summary sheet. Select B2:C13 of the summary
sheet, with B2 the active cell. Enter this equation:

=INDIRECT($A2&"!"&B$1)

and hold down Ctrl while pressing Enter. This range now has one column
with your labels from A2 in each sheet, and the next column with all the
values. Chart away.

- Jon
 
Back
Top