Relative Sheet References

  • Thread starter Thread starter rgrimsley
  • Start date Start date
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
(e-mail address removed)
Thank you!!
 
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
 
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
 
Back
Top