Thanks everyone. Some genius created a workbook with a ton of sheets with the
name of the individual being scored listed dozens of times on each sheet. So
any shortcut is good.

"David Biddulph" wrote:

Use the CELL function with the "filname" argument:
http://www.ozgrid.com/Excel/variable...heet-names.htm
http://www.exceltip.com/st/Cell_Func..._Path/180.html
http://www.cpearson.com/excel/excelf.htm
http://www.mcgimpsey.com/excel/formu..._function.html
--
David Biddulph

"RoadKill" wrote in message
...
Good afternoon good people,

I was just wondering if it is possible to fill a field with a sheet name.
So
if my sheet is named John Doe, can cell A1 be prefilled with that name?

Thank you