RagDyer Wrote:
Try this in B1:
="HD_SN "&'ED Numbers'!$A$23&INDEX('ED
Numbers'!$B$8:$B$100,(ROW(1:1)-1)/3+1)&INDEX('ED
Numbers'!$C$8:$C$100,(ROW(1:1)-1)/3+1)&"T"
This is B2:
HD_EX Y
This in B3:
HD
Select all 3 cells, and drag down to copy.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
Thanks for the tip RD, but I like Max's idea better - it is a simpler
operation.
Kind regards,
Jonathan
--
Jonibenj
------------------------------------------------------------------------
Jonibenj's Profile:
http://www.excelforum.com/member.php...o&userid=17048
View this thread:
http://www.excelforum.com/showthread...hreadid=466994