RE: $$Excel-Macros$$ Making sheet references dynamic

2010-07-26 Thread Dave Bonallack
Hi, Not quite sure if I fully understand your needs, but have a look at the attached and let me know if it suites or not. Regards - Dave. > Date: Mon, 26 Jul 2010 10:26:56 -0700 > Subject: $$Excel-Macros$$ Making sheet references dynamic > From: ejax...@gmail.com > To:

Re: $$Excel-Macros$$ Making sheet references dynamic

2010-07-26 Thread lawrence hordy
try thinking like music pages of sheetsor sheets of pagesthere will be timing loops On Mon, Jul 26, 2010 at 5:26 PM, Edgar wrote: > Hi Everyone, > > Does anyone know how to make sheet references in an equation dynamic. > Specifically, I want to list the names of a series of sheets in

$$Excel-Macros$$ Making sheet references dynamic

2010-07-26 Thread Edgar
Hi Everyone, Does anyone know how to make sheet references in an equation dynamic. Specifically, I want to list the names of a series of sheets in a column, the have an equation look up the sheet name so that the sheet it looks up changes as the cell reference changes. It should be doable, but I