Summary

Question

Hi Everyone,&nbsp;I am trying to copy an equal formula from&nbsp;A5 for different tabs ex =sheet1!G2&nbsp; &nbsp; &nbsp;Not sure how to copy this down to Row A6 formula would need to be =sheet2!G2 .&nbsp; when copying it&nbsp; down is doing =Sheet1!G3&nbsp; &nbsp;I have 50 some sheets on this workbook not looking forward to doing this manually. Thank you!&nbsp;&nbsp;&nbsp;

mikefm101 · Answer

A 3-D reference may work for this.&nbsp;see below link plus plenty of other sources if you search for Excel 3-D Reference.&nbsp;Mike&nbsp;&nbsp;https://support.microsoft.com/en-us/office/create-a-3-d-reference-to-the-same-cell-range-on-multiple-worksheets-40ca91ff-9dcb-4ad1-99d2-787d0bc888b6

bquinonessolarisfamilycom · Answer

Thanks Mike not sure why 3-D reference is not working on this one

hansvogelaar · Answer

bquinonessolarisfamilycom&nbsp;
Create a list of the sheet names in - say - Z5:Z54.
In A5:
=INDIRECT("'"&amp;Z5&amp;"'!G2")
Fill down.

Forum Discussion

Summary

Share

Resources