I have been trying to come up with a solution on my own for this, but unfortunately I am stuck.
I have a file with two sheets, with item codes and relative info and prices.
On sheet one I have the main code of the items in column A. On sheet 2 in column A I have the secondary code (the component of the main item code)
Item codes (the main and the secondary) are similar in the middle, they differ in the first character and in the last/last two. They will have the 13 characters (after the initial one, identical) E.G:
- Main Item code is X1234567891123GT
- Secondary code for the item above will be: R1234567891123YQ
I have a file with many thousands rows So I need a macro, to look in Sheet 2 Column A for a match (in the 13 characters after the first character) to item codes in Colum A SHeet 1and if match found it should copy the row starting cell D sheet 1 (so adjacent to the main item code matching).
Any input, suggestion or help is very appreciated.
thank you in advance.