Forum Discussion
Summary
Hi Everyone, I am trying to copy an equal formula from A5 for different tabs ex =sheet1!G2 Not sure how to copy this down to Row A6 formula would need to be =sheet2!G2 . when copying it down ...
Create a list of the sheet names in - say - Z5:Z54.
In A5:
=INDIRECT("'"&Z5&"'!G2")
Fill down.