Thanks Titoto. Makes a lot more sense now. I will work on it, and let you
know!

"titoto" wrote:

Sheet2
Row1
Col A: VICE
Col B: I
Col C:Blank
Col D: IF(Sheet1!I2="B","B1",IF(AND(Sheet1!I2="C",Sheet1! J2="C*"),"C1","NIL")
Col E: 3/22/05
Col F:Sheet1!F2
Col G:"CONTROL " &Sheet1!E2
Col H: 0

Row2
Col A: CONTROL
Col B: 22
Col C:'01338
Col D:Sheet2!F1
Col E:Sheet2!G1

Row3 -- X repeat formula in row1 for (Sheet1! Row2)

SHEET3

A1:"CONTROL " &Sheet1!E2
A2: blank
A3:Sheet1!$B$1&Sheet1!B2
A4:Sheet1!$C$1&Sheet1!C2
A5:Sheet1!$G$1&Sheet1!G2
A6:Sheet1!$H$1&Sheet1!H2
A7:Sheet1!$A$1&TEXT(Sheet1!A2,"mm/dd/yyyy")
A8: TO REPEAT A2 €“ A7 FOR ALL INFO IN Sheet1!