Using Excel 2003 from the student/teacher office version. I am trying to
make a workbook to track flight hours for all of the pilots in our unit. I
want to be able to tell a sheet to get its name from the text in a cell in
another sheet in the workbook. I have the last sheet as the "tracking
sheet," which has all of the pilots and their hours and ect. What I want to
do is automatically name the first sheet by refering it to the cell in the
"tracking sheet" that has the first pilots' last name. The the second sheet
would get named from the cell with the second pilots' name, and on and on.
Thanks.