View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andy Healey Andy Healey is offline
external usenet poster
 
Posts: 5
Default find sheet from list.

Hi All

I'm not sure if this is possible or not, but heres what I would like to do.

In a sheet called names in column A I have a list of sheet names.

I would like a macro to find the sheet that corresponds to the cell value
and perform a macro.

And then go onto the next cell in the list, and perform the same macro

as the list varies from month to month, and doesn't include the same names
each month I only want to perform the macro on names that exist.

Any help greatly appreciated

Cheers

Andy