Data across worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to enter a formula in the format of, "='Sheet1'!A1" and then
just click and drag and have the formula automatically go the the next sheet?
i.e "='Sheet2'!A1" instead of "='Sheet1'!A2"
 
an indirect function can do this with a little manipulation
if you start in row 3 for example
=indirect("'Sheet"&row()-2&"'!A1")
and copy this equation down it should do what you want.
 
Back
Top