Hi to everyone, kindly require to provide me support so that a VBA code, would run through col. “A” and where find the category of the items, by which the formats are like “00000001” or 00000024, should move it in col. “B” in adjacent cell of each item. Therefore, that the spreadsheet contains more than 20000 rows and should begin from row “7”. I present below the original date and the expected result. Thank you all in advance.
Original data
Expected result
Original data
Expected result