USe Contents of cell as name of worksheet in a function
Use INDIRECT
INDIRECT("'"&C2&"'!A2:A100")
for example
--
__________________________________
HTH
Bob
"lab-guy" wrote in message
...
Hi All -
I have 1 worksheet for every student, and a summary worksheet that checks
a
specific ranges in each students sheet. I manually do a find replace to
change the student's name in each column of the summary sheet.
How do I take the students name from COL C of the summary sheet and tell
the
SUMIFs in Cols E - Z to go to that students worksheet and match the
criteria
etc.. instead of manually changing the names ? (names in COL C match the
names of the students worksheets)
This worksheet is going to grow larger, and this would be very helpful.
Thank You - Mike
|