Copying Cell from Multiple Worksheets to a Summary Worksheet

[shel]

Is there a way without copying and pasting to take a cell in multiple
worksheets and insert it into a summary worksheet. I.E. On worksheet is set
up for each student. We need to be able to copy a grade from each
student/worksheet to a summary sheet where each grade will be listed in a
separate cell. We don't want to have to copy and paste from each worksheet.

 

[Luke M]

A better way might be to just use formulas.
You will need to have a list of the sheet names for this to work. Hopefully,
they're student names. Also, the grade you want would have to be in same cell
on each sheet (say, D100).

If the list of sheets/student names is on your summary sheet in cells
A2:A10, in B2 enter this:
=INDEX("'"&A2&"'!Z100")
Then just copy it down for each student.

I'm afraid there's no way to select a 3D reference of cells and copy&paste
them all into one sheet.

 

[shel]

Can you explain exactly what goes into the paratheses?

Thanks!

 

[Ron de Bruin]

Hi shel

See
http://www.rondebruin.nl/summary.htm

Or this page if you not want to use code
http://www.rondebruin.nl/linksum.htm

 

[shel]

Thanks. I think that took care of it.

--
shel

Hi shel

See
http://www.rondebruin.nl/summary.htm

Or this page if you not want to use code
http://www.rondebruin.nl/linksum.htm