In cell N10 is the name of the first item. i now have the following cells defined:
name=$N10
volume =$N11
type=$N12
A VBA macro, than uses these defined names, to calculate several formulas, this all works fine.
But know i want add more items , every 15 rows should have the same defined names
so in cell $N$26 is the name of second item
so name should refer to cells $N10 and $N26 and $N41
, $56 (so every 15 rows)
the same goes for volume and type.
Is there a function to define this?
thanks!
name=$N10
volume =$N11
type=$N12
A VBA macro, than uses these defined names, to calculate several formulas, this all works fine.
But know i want add more items , every 15 rows should have the same defined names
so in cell $N$26 is the name of second item
so name should refer to cells $N10 and $N26 and $N41
, $56 (so every 15 rows)
the same goes for volume and type.
Is there a function to define this?
thanks!