referencing other worksheets in formulas in generated Excel reports
When you write a formula in a template that references another cell on the same sheet, it increments the row number on each new row that is added by a foreach loop.
It would be great if this worked the same way for formulas referencing other worksheets.
15
votes
Jon Moyles
shared this idea