G
Guest
I want to generate a new form.
Sheet1:
Staff Att'd. Date Post JOB
CHAN 01-04-07 PA R8
WONG 01-04-07 PB IC
CHAN 01-05-07 PA IC
LEE 01-06-07 PC SP
CHAN 01-07-07 PA SP
TO THIS NEW FORM (Sheet2):
STAFF: CHAN POST: PA
DATE: JOB
01-04-07 R8
01-05-07 IC
01-07-07 SP
Thanks
GY
Sheet1:
Staff Att'd. Date Post JOB
CHAN 01-04-07 PA R8
WONG 01-04-07 PB IC
CHAN 01-05-07 PA IC
LEE 01-06-07 PC SP
CHAN 01-07-07 PA SP
TO THIS NEW FORM (Sheet2):
STAFF: CHAN POST: PA
DATE: JOB
01-04-07 R8
01-05-07 IC
01-07-07 SP
Thanks
GY