Hey guys do you think you could help me with this?
[TABLE="class: cms_table"]
Packing Schedule: Part 1
x
y
SIZE
START TIME ON E-COAT
ARRIVAL TIME
DUMP STATION
LOG006
3:30 PM
7:30 PM
4
LOG007
3:30 PM
7:30 PM
1
LOG008
3:30 PM
7:30 PM
3
LOG011
3:30 PM
7:30 PM
5
LOG012
3:30 PM
8:30 PM
4
LOG022
3:30 PM
7:45 PM
5
LOG0111
3:30 PM
8:00 PM
6
Schedule: Part 2
DUMP STATION :
1
2
3
4
5
6
TIME:
[TD="align: right"]PM
[/TD]
[TD="align: right"]PM
[/TD]
[TD="align: right"]7:30 PM
[/TD]
LOG006
[TD="align: right"]7:45 PM
[/TD]
[TD="align: right"]8:00 PM
[/TD]
[TD="align: right"]What i want to do is have the size go into part 2 based on dump station indicated above and its time. I want for example LOG006 to go into the cell where the time is 730pm and dump station 4. You can see in part 1 it tells where it goes but i want a formula where it can automatically put the size into the correct column and row.
Thank you!!!!!
[/TD]
[/TABLE]