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.
--
shel

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"shel" wrote:

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.
--
shel

Can you explain exactly what goes into the paratheses?

Thanks!

--
shel


"Luke M" wrote:

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"shel" wrote:

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.
--
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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"shel" wrote in message ...
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.
--
shel

Thanks. I think that took care of it.

--
shel


"Ron de Bruin" wrote:

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"shel" wrote in message ...
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.
--
shel