Drag and Fill

I have a formula :

=INDIRECT("TR1!E"&COUNTA(TR1!E:E))

And I would like to be able to drag and fill this formula so that for each successive cell, the 1 in both instances of "TR1!" changes to a 2, then a 3, and so forth, so that the cells look like this:

=INDIRECT("TR2!E"&COUNTA(TR2!E:E))
=INDIRECT("TR3!E"&COUNTA(TR3!E:E))


Is there a way to do this or am I doomed to changing every single cell in my spreadsheet manually?

There's always a way. It's just a question as to whether it's worth it or not. Here's what I came up with.

Please Login or Register  to view this content.

As you drag down, ROW(A1), which equals 1, goes to Row(A2) (=2) and so forth.

ChemistB

Oh My Lord.. You just saved me HOURS upon HOURS of busy work. Thank you!!

Oh My Lord.. You just saved me HOURS upon HOURS of busy work.

Well then, I'm glad I helped.

ChemistB