1 =IF(AB413="No Data","",'Data Entry (yearly)'!AQ6)

Code 1 =IF(AB413="No Data","",'Data Entry (yearly)'!AR6)

Position 1 =IF(AB413="No Data","",'Data Entry (yearly)'!AS6)

2 =IF(AB414="No Data","",'Data Entry (yearly)'!AQ7)

code 2 =IF(AB414="No Data","",'Data Entry (yearly)'!AR7)

postion 2 =IF(AB414="No Data","",'Data Entry (yearly)'!AS7)

How would I drag these sets of three rows down as shown from 1 to 2 ???



I am very stuck!! If anyone could help me out with this problem it
would be great appreciated!!!
Thank You in advance!!

thanks,
Matt