Forum Discussion
Extending formulas between sheets
I have multiple sheets that I would like to connect with a simple cell=sheet1 type formula. My problem is that when I extend it out the cell spacing is different between the sheets. For example, shee...
Hi Jonathan65
you could give the source cells or cell ranges a name (menu "Formulas | Define Name") and then use this names in the other sheets as a reference, instead of using cell adresses.
I have no idea if this makes sense in your scenario, but as there are no screenshots or example file, this would be my first advise.