To support solution to this Thread:
http://www.excelfox.com/forum/showth...and-send-email


Test data supplied by Thainguyen for this Thread :
http://www.excelfox.com/forum/showth...and-send-email



Code:
Using Excel 2007 32 bit
Row\Col
A
B
C
D
E
F
G
H
I
J
K
N
1
Equipment PM
2
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
Softwear
3
4
1
JUKI GKG GL GL SCREEN PRINTER A123
06.04.2018
13.04.2018
15.03.2018
12.04.2018
N/A
N/A
5
2
JUKI KE-1070L SMT Placement Machine A124
11.04.2018
18.04.2018
28.03.2018
25.04.2018
N/A
N/A
6
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
7
59
Heller 1826 MK5 Reflow Oven A126
N/A
N/A
16.03.2018
13.04.2018
N/A
N/A
8
62
Exit Sign -- N/A -- Exit Lights N/A N/A A127
N/A
N/A
N/A
N/A
N/A
N/A
9
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
10
75
ACE Production KISS-102 Selective Wave Solder A129
16.04.2018
23.04.2018
N/A
N/A
N/A
N/A
11
101
FKN system N100 Nibbler Dispensing A130
N/A
N/A
N/A
N/A
04.04.2018
02.05.2018
12
109
Mycronic MY200sx SMT Machine A131
N/A
N/A
N/A
N/A
N/A
N/A
13
112
X-TEK XTV-160 X-Ray System A132
N/A
N/A
N/A
N/A
N/A
N/A
14
113
MIRTEC MV-6 OMNI AOI A133
N/A
N/A
N/A
N/A
N/A
N/A
15
116
JUKI KE-2060RL SMT Placement Machine A134
N/A
N/A
N/A
N/A
N/A
N/A
16
127
ELGI EG22-150 Air Compressor A135
N/A
N/A
N/A
N/A
N/A
N/A
17
128
Juki KE-2050 SMT A136
N/A
N/A
N/A
N/A
N/A
N/A
18
137
Juki K3 Screen printer A137
06.04.2018
13.04.2018
N/A
N/A
N/A
N/A
19
141
Heller 1826 MK5 Reflow Oven A138
N/A
N/A
N/A
N/A
N/A
N/A
20
142
NISSAN MCU-112A331.V Forklift A139
N/A
N/A
N/A
N/A
15.02.2018
15.03.2018
21
142
NISSAN/yearly oil change and lube MCU-112A331.V Forklift A140
N/A
N/A
N/A
N/A
N/A
N/A
22
28.01.1900
23
Worksheet: Equipment PM