With VBA
For Each sh In ACtiveworkbbok.Worksheets
sh.Name = sh.Range("A2").Value
Next sh
--
HTH
Bob Phillips
"Mark T" <Mark [email protected]> wrote in message
news:[email protected]...
> If I have 100+ sheets with with data for a single day on each sheet. The
date
> of data located in cell A2. Is there a quick way to rename all the sheets
to
> match what is in cell A2 of each sheet.
Bookmarks