How to skip cells and/or columns based on conditions?

[Andries]

Hi

I have 2(two) Tables as you can see below. The first table is the master time table sheet where all the data is kept. Data must be transferred from this sheet to TABLE 2. TABLE 2 shows how the end result should look like. When you look at the SEAT NR column in TABLE 2 you will note that each set of seats (A-1...B-1..C-1..D-1) does not have the same number of seats. What the formula should do is to look in Column D on the Master Time Table sheet if there is any "O/B"'s at the back of any one of descriptions and if so it should start in a new set of seats e.g. B-1.

If it helps in any way please note that data have been sorted so that all "O/B" types are together so they are not scattered all over.

Kind Regards,
Dries

Excel Workbook
	A	B	C	D	E	F
1	MASTER TIME TABLE
2	Exam date	Session	Subject code	Description	No Students	Duration
3	30-May-11	X	AAD101C	ENGLISH	6	180
4	30-May-11	X	AAD111D	MATHS-O/B	6	240
5	30-May-11	X	ADM20AT	CHEMISTRY-O/B	16	240
POPULATED SEATS (2)

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
13	TABLE 2
14	SEAT NR	SUBJECT	SEAT NR	SUBJECT	SEAT NR	SUBJECT	SEAT NR	SUBJECT	SEAT NR	SUBJECT	SEAT NR	SUBJECT	SEAT NR	SUBJECT	SEAT NR	SUBJECT	SEAT NR	SUBJECT
15	A-1	English	B-1	MATHS-O/B	C-1	*	D-1	MATHS-O/B	E-1	*	F-1	CHEMISTRY-O/B	G-1	*	H-1	CHEMISTRY-O/B	I-1	*
16	A-2	English	B-2	MATHS-O/B	C-2	*	D-2	CHEMISTRY-O/B	E-2	*	F-2	CHEMISTRY-O/B	G-2	*	H-2	CHEMISTRY-O/B	I-2	*
17	A-3	English	B-3	MATHS-O/B	C-3	*	D-3	CHEMISTRY-O/B	E-3	*	F-3	CHEMISTRY-O/B	G-3	*	H-3	CHEMISTRY-O/B	I-3	*
18	A-4	English	B-4	MATHS-O/B	C-4	*	D-4	CHEMISTRY-O/B	E-4	*	F-4	CHEMISTRY-O/B	G-4	*	H-4	CHEMISTRY-O/B	I-4	*
19	A-5	English	B-5	MATHS-O/B	C-5	*	D-5	CHEMISTRY-O/B	E-5	*	F-5	CHEMISTRY-O/B	G-5	*	H-5	CHEMISTRY-O/B	I-5	*
20	A-6	English	B-6	*	*	*	*	*	*	*	*	*	G-6	*	H-6	CHEMISTRY-O/B	I-6	*
21	A-7	*	B-7	*	*	*	*	*	*	*	*	*	G-7	*	H-7	CHEMISTRY-O/B	I-7	*
22	A-8	*	B-8	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
23	A-9	*	B-9	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
POPULATED SEATS (2)