Hi,
Is it possible to compare 2 fields as follows.
Check if columnA contains "Size2", if yes then Column D must equal UK 2 If incorrect give error box saying "Size Error" and stop code, if OK continue
Check if columnA contains "Size3", if yes then Column D must equal UK 3 If incorrect give error box saying "Size Error", and stop code, if OK continue
Check if columnA contains "Size4", if yes then Column D must equal UK 4 If incorrect give error box saying "Size Error", and stop code, if OK continue
Check if columnA contains "Size5", if yes then Column D must equal UK 5 If incorrect give error box saying "Size Error", and stop code, if OK continue
Check if columnA contains "Size6", if yes then Column D must equal UK 6 If incorrect give error box saying "Size Error", and stop code, if OK continue
Check if columnA contains "Size7", if yes then Column D must equal UK 7 If incorrect give error box saying "Size Error", and stop code, if OK continue
Check if columnA contains "Size8", if yes then Column D must equal UK 8 If incorrect give error box saying "Size Error", and stop code, if OK continue
Check if columnA contains "Size9", if yes then Column D must equal UK 9 If incorrect give error box saying "Size Error", and stop code, if OK continue with rest of code
We need the macro to check all rows in the spreadsheet that contain data, if the row does not contain any of the above then it is OK to continue.
Also to clarify the ColumnA will be something like "ATA1 BLACK SU#Size3" So it will contain Size3 and not be equal to Size3
Any help with this would be really appreciated as I am stuck on this and it would make my Macro perfect for what we need as It will hopefully make listing size errors a thing of the past.
Regards,
Usman
Bookmarks