Prev: Conditional Formatting - to highlight overwritten formulas
Next: EXTENSION OF EXCEL SHEET COLUMNS BEYOND IV GRID
From: ferne on 19 May 2010 21:55 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 > > . > |