I dont know how to describe it, better use pic ><
This is the data resources i want to make reference
data.png
then i want to be like format as this
the formula is me manual key in
data 2.png
but then if i copy and paste it will become
data 3.png
The no. in formula jump from 1 to 5 according to the active sheet row no.
how to i do if i want to follow the criteria 1,2,3,4,5 but not manual key in
Bookmarks