Thanks for the info. Will let you know soonest. Will be on 23/3

"titoto" wrote:

Kassie I hope the following is helpful in understanding what I am trying to
achieve Sheet1 contains

A B C D E F G H
I J
1 cpl Pri By type num loc Rm Ins PM
olt
2 9/20/04 John A. 108379 5 N - YRT 5555 B IOT B
3 1/12/04 Marc R. 204464 85 W - NYJ 5555 DL IOT DL
4 9/23/04 Anna M. 199168 18 SW - KHG 5555 B IOT B
5 1/12/04 Andre Y. 156241 6 S - MVD 5555 C IOT C*
6 9/23/04 Lhea G. 189448 15 E - PLJ 5555 H IOT H
7 1/01/04 Bruce V. 107287 36 NE - CWA 5555 Y IOT Y

Sheet2 should do
A B C D E F G
H I J
1 VICE I See below 3/22/05 Sheet1!F2 See below
0
2 ACTION 22 01338 =Sheet2!F1 =Sheet2!G1
3 VICE I see below 3/22/05 Sheet2!F3 See below 0
4 Same as 2
5 REAPET
Row 1
D1 = IF(Sheet1!I2="B","B1",IF(AND(Sheet1!I2="C",Sheet1! J2="C*"),"C1","NIL
G1 ="CONTROL " &Sheet1!E2

Row 3
D1 = IF(Sheet1!I3="B","B1",IF(AND(Sheet1!I3="C",Sheet1! J3="C*"),"C1","NIL
G1 ="CONTROL " &Sheet1!E3

To repeat for each row of sheet1 that contains info.

Sheet3
A
1 See below
2 blank
3 See below
4 See below
5 See below
6 See below
7 See below
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!