VBA, require each line remaining part list.
Hello,
1-I got unique part list in the cells M2:AF2
2-Sold part list in the B4:J2000
3-Need help with VBA that give a remaining part list in the cells M4:AF200 (comparing sold part of each line in the columns B:J with unique list M2:AF2)
For example the sample image is attached.
Thank you all.
I am using Excel 2000
Regards,
Moti
Hello,
1-I got unique part list in the cells M2:AF2
2-Sold part list in the B4:J2000
3-Need help with VBA that give a remaining part list in the cells M4:AF200 (comparing sold part of each line in the columns B:J with unique list M2:AF2)
Unique | |||||||||||||||||||||||||||||||
Item | Item | Item | Item | Item | Item | Item | Item | Item | Part List | 12 | 27 | 32 | 75 | 86 | 90 | 98 | 100 | 107 | 124 | 137 | 138 | 139 | 140 | 145 | 152 | 157 | 210 | 242 | 249 | ||
Sold | Sold | Sold | Sold | Sold | Sold | Sold | Sold | Sold | |||||||||||||||||||||||
12 | 32 | 86 | 90 | 124 | 145 | 157 | 210 | 242 | Remaining | 27 | 75 | 98 | 100 | 107 | 137 | 138 | 139 | 140 | 152 | 249 | |||||||||||
32 | 86 | 100 | 107 | 137 | 139 | 152 | 242 | 249 | Remaining | 12 | 27 | 75 | 90 | 98 | 124 | 138 | 140 | 145 | 157 | 210 | |||||||||||
27 | 75 | 86 | 90 | Remaining | 12 | 32 | 98 | 100 | 107 | 124 | 137 | 138 | 139 | 140 | 145 | 152 | 157 | 210 | 242 | 249 | |||||||||||
100 | 107 | 124 | 145 | 152 | 242 | Remaining | 12 | 27 | 32 | 75 | 86 | 90 | 98 | 137 | 138 | 139 | 140 | 157 | 210 | 249 | |||||||||||
Remaining | |||||||||||||||||||||||||||||||
Remaining | |||||||||||||||||||||||||||||||
Remaining | |||||||||||||||||||||||||||||||
Remaining | |||||||||||||||||||||||||||||||
Remaining | |||||||||||||||||||||||||||||||
Remaining | |||||||||||||||||||||||||||||||
Remaining | |||||||||||||||||||||||||||||||
Remaining |
For example the sample image is attached.
Thank you all.
I am using Excel 2000
Regards,
Moti