Hello,
My sheet 1 A column contains the part numbers with file extension and also corresponding rows are having some other data with related to A column
1. The Sheet 1 A column data ( part numbers with extension ie: 12346.prt, 456789.asm, 987456.drw ) are having duplicate values so, I want to delete the duplicate part numbers and their corresponding row also, then
2. Remove the file Extensions from sheet 1 A cell data(Ie: 12346, 456789, 987456)
3. Vlookup the A column part numbers with another master data (A cell) which is available in the another sheet but same workbook.
4. If the part number is not present [/COLOR]in the Master data sheet then copy the value to sheet3(A Cell),
5. Not presented A data equalent D, G, L, C, V cell data also copied to Sheet 3 b,c,d,e,f cells respectively
I am a beginner of VBA coding so, if you write the simple coding would be appreciated.
Regards,
KK
Bookmarks