Copying Cell from Multiple Worksheets to a Summary Worksheet

S

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top