Dear Pete
The idea of using Row() function to produce reference address is great, anf
this is actually what I was looking for. So thank you very much for your pure
knowledge in this issue.
BTW I would like to learn Macro and automatize some of these works. Which
book or site do you recomend for start?
I have tried to learn Macro and I have the basic knowledge but my main
problem is how to change the address (or use relative address) when I want to
perform same Macro for different sheet (sheet run1 to run50)
--
Rasoul Khoshravan Azar
Civil Engineer
Osaka, Japan


"Pete_UK" wrote:

On reflection, I think you probably want 50 different values, so you
can make use of the ROW( ) function to give you the increment for your
"run" sheets. Assuming you have some description in column A, and that
your first formula is in row 3 (to allow for headings etc), then enter
this in B3:

=INDIRECT("'run"&(ROW()-2)&"'!G$1")

and copy down for 50 rows. You want the expression in the middle to
evaluate to 1 for your first row, so if this is on row 5 then change it
to:

(ROW()-4)

The apostrophes are not strictly necessary if you do not have spaces in
the sheet names.

Hope this helps.

Pete