One thought on your 2nd Q:
INDEX(Data!$B$2:$C$3000,COUNTA(Data!A:A)-1,1)&INDEX(Data!$B$2:$C$3000,COUNTA(Data!A:A)-1,2).
For Pd 01 Wk 3 the formula will show: 013
How can I format it to show 01x3 ?
I have tried to concatenate &"X"&INDEX.... but it didn't work.

Maybe you could try it this way:
=text(index(1),"00")&"x"&index(2)
where the TEXT function is used to format the numeric? return from index(1)
to show the desired leading zero
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---