View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MikeD1224 MikeD1224 is offline
external usenet poster
 
Posts: 34
Default Alter mulitple Vlookups at once

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