Hi Max, i have similar hassle. each of my worksheets has a persons name.
Such as David, james, Fred.
On one front sheet, I am trying to combine all the info. Example: Overtime
(will read off same cell but on 20 differnt sheets). Like Freddie wrote, i
don't want to sit and change the names for each cell.
On front sheet i have B1 James, B2 Fred, B3 David etc
In C1, C2, C3 etc i want to read the overtime rate (H10) from each of their
sheets.
Going wrong somewhere with the formula you suggested for freddie. can you
help. Thanks Ali


"Max" wrote:

One way ..

Assuming you have listed across
in B1, C1, etc the "months":Jan, Feb ... etc

then you could put in say B2:
=INDIRECT("'"&B1&" 04'!F17")+INDIRECT("'"&B1&" 04'!F19")+INDIRECT("'"&B1&"
04'!F25")

This returns in B2 the functional equivalent of:
=(+jan 04'!$f17+'jan 04'!$f19+jan 04'!$f25)

Just copy B2 across to C2
to return the equivalent in C2 of:
=(+feb 04'!$f17+'feb 04'!$f19+feb 04'!$f25)

and so on
--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <atyahoo<dotcom
----
"Freddie" wrote in message
...
Please can some one help me,
I am trying to get a quick way of coping a formula without having to
manualy
change the sheet name.

example:

sheet 10 formula consists of adding b3 + b4 + b6 + b 9 + b23 from sheet1

now i want to copy this formula for sheet 2, but without having to
manually
change the "name" from sheet1 to sheet2

my current formula looks like


=(+jan 04'!$f17+'jan 04'!$f19+jan 04'!$f25)

i now want the cell next to the cell with the above formula to read
=(+feb 04'!$f17+'feb 04'!$f19+feb 04'!$f25)

thank you in advance

On front sheet i have B1 James, B2 Fred, B3 David etc
In C1, C2, C3 etc i want to read the overtime rate (H10)
from each of their sheets.

Put in C1:
=INDIRECT("'"&B1&"'!H10")
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Ali" wrote in message
...
Hi Max, i have similar hassle. each of my worksheets has a persons name.
Such as David, james, Fred.
On one front sheet, I am trying to combine all the info. Example:
Overtime
(will read off same cell but on 20 differnt sheets). Like Freddie wrote,
i
don't want to sit and change the names for each cell.
On front sheet i have B1 James, B2 Fred, B3 David etc
In C1, C2, C3 etc i want to read the overtime rate (H10) from each of
their
sheets.
Going wrong somewhere with the formula you suggested for freddie. can you
help. Thanks Ali

Thanks Max, works like a charm. Must have been missing an apostrophe
somewhere. Much appreciated

"Ali" wrote:

Hi Max, i have similar hassle. each of my worksheets has a persons name.
Such as David, james, Fred.
On one front sheet, I am trying to combine all the info. Example: Overtime
(will read off same cell but on 20 differnt sheets). Like Freddie wrote, i
don't want to sit and change the names for each cell.
On front sheet i have B1 James, B2 Fred, B3 David etc
In C1, C2, C3 etc i want to read the overtime rate (H10) from each of their
sheets.
Going wrong somewhere with the formula you suggested for freddie. can you
help. Thanks Ali


"Max" wrote:

One way ..

Assuming you have listed across
in B1, C1, etc the "months":Jan, Feb ... etc

then you could put in say B2:
=INDIRECT("'"&B1&" 04'!F17")+INDIRECT("'"&B1&" 04'!F19")+INDIRECT("'"&B1&"
04'!F25")

This returns in B2 the functional equivalent of:
=(+jan 04'!$f17+'jan 04'!$f19+jan 04'!$f25)

Just copy B2 across to C2
to return the equivalent in C2 of:
=(+feb 04'!$f17+'feb 04'!$f19+feb 04'!$f25)

and so on
--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <atyahoo<dotcom
----
"Freddie" wrote in message
...
Please can some one help me,
I am trying to get a quick way of coping a formula without having to
manualy
change the sheet name.

example:

sheet 10 formula consists of adding b3 + b4 + b6 + b 9 + b23 from sheet1

now i want to copy this formula for sheet 2, but without having to
manually
change the "name" from sheet1 to sheet2

my current formula looks like


=(+jan 04'!$f17+'jan 04'!$f19+jan 04'!$f25)

i now want the cell next to the cell with the above formula to read
=(+feb 04'!$f17+'feb 04'!$f19+feb 04'!$f25)

thank you in advance

welcome.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Ali wrote:
Thanks Max, works like a charm. Must have been missing an apostrophe
somewhere. Much appreciated