Hi, I have a formula =’Child 40′ !$V$38. I need to copy formula down for another 40 cells but change the child number each time in sequence keeping same cell reference, I’m stuck on how to do it.

​Hi, I have a formula =’Child 40′ !$V$38. I need to copy formula down for another 40 cells but change the child number each time in sequence keeping same cell reference, I’m stuck on how to do it.   Read More

​