Hi Jason,

Am Thu, 2 Oct 2014 05:35:26 +0100 schrieb JasonL:

Company AXB ATA ATA ATA AXB
Run 1 2 3 4 5
PayData 5555 6666 777 888 999
PayData 5555 6666 777 888 999
PayData 5555 6666 777 888 999

for AXB
in A1: =INDEX(Master!A:A,ROW())
in B1: =INDEX(Master!B:B,ROW())
in C1: =INDEX(Master!F:F,ROW())
and copy down.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional