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.

callsign Blue Wolf One Five wrote:
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.

----------------

For example, if you have a last name in Sheet1 cell A1, then you can
access cell B5 on the sheet named in A1 by:

= INDIRECT((Sheet1!A1&"!$B$5"),TRUE))

This takes the name from A1, and concatenates it with the desired cell
from that page to form a good cell address, and then gets the contents.

Play with it a little and you'll see how it works.

(I hope you don't have two people named SMITH!)

Good luck...

Bill

Thanks for the info Bill.

"Bill Martin -- (Remove NOSPAM from addre" wrote:

callsign Blue Wolf One Five wrote:
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.

----------------

For example, if you have a last name in Sheet1 cell A1, then you can
access cell B5 on the sheet named in A1 by:

= INDIRECT((Sheet1!A1&"!$B$5"),TRUE))

This takes the name from A1, and concatenates it with the desired cell
from that page to form a good cell address, and then gets the contents.

Play with it a little and you'll see how it works.

(I hope you don't have two people named SMITH!)

Good luck...

Bill