Another view of last table

( for Thread: http://www.excelfox.com/forum/showth...and-send-email )

Using Excel 2007 32 bit
Equipment PM
Machine EQ.ID
Manufacture
Model
Description
Serial Number
Weekly
Date of Service
Weekly
Next Service
Monthly
Date of Service
Monthly
Next Service
Quarterly
Date of Service
Quarterly
Next Service
1
 JUKI GKG GL GL SCREEN PRINTER A123
06.04.2018
13.04.2018
15.03.2018
12.04.2018
N/A
N/A
2
 JUKI KE-1070L SMT Placement Machine A124
11.04.2018
18.04.2018
28.03.2018
25.04.2018
N/A
N/A
9
 ACE Production KISS-101B Selective Wave Solder A125
06.04.2018
13.04.2018
15.03.2018
12.04.2018
N/A
N/A
59
 Heller 1826 MK5 Reflow Oven A126
N/A
N/A
16.03.2018
13.04.2018
N/A
N/A
62
 Exit Sign -- N/A -- Exit Lights N/A N/A A127
N/A
N/A
N/A
N/A
N/A
N/A
69
 South-Tek System N2-Gen 35ST Nitrogen Generator A128
10.04.2018
17.04.2018
N/A
N/A
09.03.2018
06.04.2018
75
 ACE Production KISS-102 Selective Wave Solder A129
16.04.2018
23.04.2018
N/A
N/A
N/A
N/A
101
 FKN system N100 Nibbler Dispensing A130
N/A
N/A
N/A
N/A
04.04.2018
02.05.2018
109
 Mycronic MY200sx SMT Machine A131
N/A
N/A
N/A
N/A
N/A
N/A
112
 X-TEK XTV-160 X-Ray System A132
N/A
N/A
N/A
N/A
N/A
N/A
113
 MIRTEC MV-6 OMNI AOI A133
N/A
N/A
N/A
N/A
N/A
N/A
116
 JUKI KE-2060RL SMT Placement Machine A134
N/A
N/A
N/A
N/A
N/A
N/A
127
 ELGI EG22-150 Air Compressor A135
N/A
N/A
N/A
N/A
N/A
N/A
128
 Juki KE-2050 SMT A136
N/A
N/A
N/A
N/A
N/A
N/A
137
 Juki K3 Screen printer A137
06.04.2018
13.04.2018
N/A
N/A
N/A
N/A
141
 Heller 1826 MK5 Reflow Oven A138
N/A
N/A
N/A
N/A
N/A
N/A
142
 NISSAN MCU-112A331.V Forklift A139
N/A
N/A
N/A
N/A
15.02.2018
15.03.2018
142
 NISSAN/yearly oil change and lube MCU-112A331.V Forklift A140
N/A
N/A
N/A
N/A
N/A
N/A
28.01.1900
Worksheet: Equipment PM