Hi,
I have various data in column C on my sheet.
Here are a couple of examples:
NESC DLC GST Esp Honduras 12Cap 6x72g QW
NESCAFE DLC GST LtMac 16Cap 6x194.4g QW
Most of the data is different but the 12Cap & 16Cap are always there and it's the last entry in column C I am after.
I was wondering if it was possible a vba code could find these and returns a message box saying 12Cap and the same for 16Cap.
I hope this makes sense.
Thanks
Dan
I have various data in column C on my sheet.
Here are a couple of examples:
NESC DLC GST Esp Honduras 12Cap 6x72g QW
NESCAFE DLC GST LtMac 16Cap 6x194.4g QW
Most of the data is different but the 12Cap & 16Cap are always there and it's the last entry in column C I am after.
I was wondering if it was possible a vba code could find these and returns a message box saying 12Cap and the same for 16Cap.
I hope this makes sense.
Thanks
Dan