Prev: Reference(s) to worksheets for building graphs
Next: File placement with copied sheets
From: Radhakant Panigrahi on 31 May 2010 08:42
Hi ,

I am using the sheet reference in a formula. the sheets are named on the
basis of dates of a month...

So i have to change the formula in every month and change the date in the
fromula in almost 200 sheets...

Is there any help in excel where i can to put the formula once and enevif i
am chaning the date of the sheets in different months the formula remain same


regards,
radha
From: Don Guillett on 31 May 2010 09:30
You didn't post your formula
Have a look in the help index for INDIRECT

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Radhakant Panigrahi" <rkp.gen(a)gmail.com> wrote in message
news:E86A58A7-6C22-4E6E-8504-199DB84BECFA(a)microsoft.com...
> Hi ,
>
> I am using the sheet reference in a formula. the sheets are named on the
> basis of dates of a month...
>
> So i have to change the formula in every month and change the date in the
> fromula in almost 200 sheets...
>
> Is there any help in excel where i can to put the formula once and enevif
> i
> am chaning the date of the sheets in different months the formula remain
> same
>
>
> regards,
> radha

From: Mike H on 31 May 2010 09:55
Hi,

Post a sample (Typical) sheet name and some code that refers to this name.
Are all the sheets named to the same convention?


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Radhakant Panigrahi" wrote:

> Hi ,
>
> I am using the sheet reference in a formula. the sheets are named on the
> basis of dates of a month...
>
> So i have to change the formula in every month and change the date in the
> fromula in almost 200 sheets...
>
> Is there any help in excel where i can to put the formula once and enevif i
> am chaning the date of the sheets in different months the formula remain same
>
>
> regards,
> radha
 | 
Pages: 1
Prev: Reference(s) to worksheets for building graphs
Next: File placement with copied sheets