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 ...
A 3-D reference may work for this.
see below link plus plenty of other sources if you search for Excel 3-D Reference.
Mike
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
- Thanks Mike not sure why 3-D reference is not working on this one
