Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
USe Contents of cell as name of worksheet in a function
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use of the Contents of a cell as a worksheet name in a function | Excel Worksheet Functions | |||
Reflect cell contents into another worksheet | Excel Discussion (Misc queries) | |||
Reflect cell contents into another worksheet | Excel Discussion (Misc queries) | |||
Reflect cell contents into another worksheet | Excel Discussion (Misc queries) | |||
What worksheet function will formatlessly copy cell contents? | Excel Worksheet Functions |