From: ferne on
Thanks for your help
--
ferne


"ozgrid.com" wrote:

> Yes, list you worksheet names in any Column and use INDIRECT.
>
>
>
> --
> Regards
> Dave Hawley
> www.ozgrid.com
> "ferne" <ferne(a)discussions.microsoft.com> wrote in message
> news:03F6D9ED-544F-48F9-8C54-3A558210DE2F(a)microsoft.com...
> >I have a yearly summary worksheet by week. Each week i add the weekly
> >report
> > to the workbook. I need a formula on the summary sheet that will change
> > the
> > worksheet name when I copy it down. Is there any way to do this? Would
> > send
> > a copy of my workbook but nowhere to attach it.
> > --
> > ferne
>
> .
>