copy data from a sheet but i have a duplicate data.

maybe so

Please Login or Register  to view this content.

Here The Files Sir. i Try here but i have a probelem

here's your file, please try again

what the code i need to change if i transfer the vendors data in Cell C ?? and the result for sheet 2 will transfer in B6 ??

Please Login or Register  to view this content.

Wow Its Working Thankyou somuch nilem. GODBLESS you and This Forum.

sorry for other question. what about the sheet, what if the vendors data is in sheet 5 how to change it ??

Please Login or Register  to view this content.

Thanks you so much nilem GOD Bless

Sorry again for another question.
what if i want in sheet5 get the vendors name C2 to c6000 ??

You've been asked this question
See. post #8

The Sheet5 ?
my question sir is like for example in sheet 1 i have A1 to A500 list of data and they Have a duplicate.
after that i input a data in A1500 when i run the macro. the result in sheet i not read the data i input in A1500.

Sorry if i write a wrong grammar sir. GODBLESS

i try this but i have an error

Please Login or Register  to view this content.