a function which enters current cell address into a formula??

[ntsheehy]

I'm trying to make a formula which adds numbers from the same cel
address (i.e. column letter and row number) from various worksheets
This same type of formula will be used over 200 times but each time th
cell address will change. My question is: is there some function whic
will automatically use the selected cells address so that I can creat
one formula and paste it into many different cells.

example
here's an example formula to help understand my question:

Joe Smith's data is in cell E92 for every worksheet. In the "final
worksheet I need to sum up his data.

=SUM('Sheet1'!E92)+('Sheet2'!E92)+('Sheet3'!E92)

but then I'll need to do the exact same thing for Jane Doe and her dat
is in M188....is there anyway to do this without manually changing th
formula and replacing all of the E92 with M188????

Otherwise I'm going to have to enter 200+ different cell addresses on
cell at a time!!!

Please help!!

feel free to email me at (e-mail address removed)

Thanks,
Nei

 

[Ron Rosenfeld]

I'm trying to make a formula which adds numbers from the same cell
address (i.e. column letter and row number) from various worksheets.
This same type of formula will be used over 200 times but each time the
cell address will change. My question is: is there some function which
will automatically use the selected cells address so that I can create
one formula and paste it into many different cells.

example
here's an example formula to help understand my question:

Joe Smith's data is in cell E92 for every worksheet. In the "final"
worksheet I need to sum up his data.

=SUM('Sheet1'!E92)+('Sheet2'!E92)+('Sheet3'!E92)

but then I'll need to do the exact same thing for Jane Doe and her data
is in M188....is there anyway to do this without manually changing the
formula and replacing all of the E92 with M188????

Otherwise I'm going to have to enter 200+ different cell addresses one
cell at a time!!!

Please help!!

feel free to email me at (e-mail address removed)

Thanks,
Neil


---

Not knowing much about how your workbook is set up, I would suggest you look at
the INDIRECT function. You could store the required cell address in some cell,
and reference that cell in your formulas.


--ron

 

[RagDyer]

See your original post in the misc. group.

I'm trying to make a formula which adds numbers from the same cell
address (i.e. column letter and row number) from various worksheets.
This same type of formula will be used over 200 times but each time the
cell address will change. My question is: is there some function which
will automatically use the selected cells address so that I can create
one formula and paste it into many different cells.

example
here's an example formula to help understand my question:

Joe Smith's data is in cell E92 for every worksheet. In the "final"
worksheet I need to sum up his data.

=SUM('Sheet1'!E92)+('Sheet2'!E92)+('Sheet3'!E92)

but then I'll need to do the exact same thing for Jane Doe and her data
is in M188....is there anyway to do this without manually changing the
formula and replacing all of the E92 with M188????

Otherwise I'm going to have to enter 200+ different cell addresses one
cell at a time!!!

Please help!!

feel free to email me at (e-mail address removed)

Thanks,
Neil

 

[Mike A]

If the INDIRECT() function works for your workbook, you may want to
combine it with a VLOOKUP() function and create a table which maps your
people to their data. You can copy the formula, and since people come
and go, it will be easier to maintain your file.

Mike Argy
Custom Office solutions and
Windows/UNIX applications

 

[DW]

If I understand your inquiry correctly you can copy, paste special,
formula - or edit, replace, enter cell references, replace all.