VBA Coding for remove & Vlookup &copy

[KSQUARE2K6]

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

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[KSQUARE2K6]

Hello,

Thanks for your reply....

Unfortunately this is not works…


For your better understanding, I just make the sample excel and attached here for your reference.

Sheet 1 contain the input data
Sheet 2 contain the master data
Sheet 3 contain the output data
Guidance about the sample excel
Sheet 1:
Check the duplicates and remove the extension and copy the part number and corresponding data in sheet 3
Red colour filled items are duplicated item so it is removed in the sheet 3 data and also extensions are removed

Sheet 2:
Yellow colour Highlighted numbers are available in sheet 1 so, those numbers are removed and remaining part numbers are copied in the sheet 3
Sheet 3:
Sheet 1 A cells are copied to Sheet 3 A cell
Sheet 1 b cells are copied to Sheet 3 b cell
Sheet 1 E cells are copied to Sheet 3 c cell
Sheet 1 G cells are copied to Sheet 3 D cell
Sheet 1 H cells are copied to Sheet 3 E cell


Hope This sample excle will give the clear idea about my requirment

Regards,
KK

[JOHN H. DAVIS]

Sorry, Maybe:

Please Login or Register  to view this content.

[AB33]

Another option

[KSQUARE2K6]

Hello,

I just delete the sheet 3 from my sample excel and apply your coding. It seems that, the coding is not working.

I would recommend you to delete the sheet 3 from your end and cross check once again.

Highly appreciated your help.

Regards,
KK

[AB33]

KK,
I do not know which code you are referring to.
The data you have in sheet3 are produced by the code. The code first clears the data in sheet3 and populate it with new data. If you deleted sheet3, you will get an error called "Out of range" as sheet3 does not exist.