Might be worth trying
=IF(OFFSET(AB$413,INT(ROW()-1/3),0)="No Data","",'Data Entry
(yearly)'!OFFSET($AQ$6,INT(ROW()-1/3),MOD(ROW()-1,3))
(assuming that your first formula is in row 1; if not, change the number
that you subtract from ROW() in the various places in the formula).
--
David Biddulph

wrote in message
ups.com...
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