Relative Sheet References

R

rgrimsley

I have 50 worksheets with data, that I want to summarize
on a sumary sheet. I have created the link to the cell
on the first worksheet. I when I copy and paste the
link, the cell reference changes relative to the row
below, etc. I also want the sheet to change from the
Sheet 1 to Sheet 2, etc.
Can I do this? Please say yes. And then give me a
little diretion on how.
I don't use newsgroups very often, so if anyone knows the
answer, could you email me at
[email protected]
Thank you!!
 
F

Frank Kabel

Hi
do the worksheet names follow a logig. e.h.
wks1
wks2
wks3

If yes you may post some more detail and a combination of INDIRECT()
and ROW might help you
 
K

Ken Wright

Or if they all have the exact same structure in terms of rows/columns and you
were looking to summarise every cell A3 for example, then is quite easily done
with a 3D range
 
Top