Hi Mike,

You can do that with Find & Replace on each sheet. However, before doing that, I'd suggest giving your lookup range a defined name,
then use that as the replace value. This way, next time your lookup table changes, changing the range referred to in the defined
name will update all sheets automatically.

Cheers

--
macropod
[MVP - Microsoft Word]


"MikeD1224" wrote in message ...
| I have series of spreadsheets that contains a date in cell A2. In cell A1 on
| each of these sheets is a Vlookup to a schedule sheet (in same workbook) that
| pulls in the Theme title for that particular sheet.
|
| The schedule layout has been changed and I need to modify each Vlookup
| across 60 worksheets. Is there a quick way to modify all the worksheets at
| once to change the Vlookups?
|
| Thanks
|
|