Copy data and paste it to next sheet with conditions

[HaroonSid]

hi,
I am using below code to copy paste data one sheet to next sheet

Please Login or Register  to view this content.

"sheet1" range A7:A have unique number ( like 1-100000000)
if from sheet1.range("A7:A"), any number found in Sheet2.range.("A:A")
then appers a msgbox with "number already added"
if not found then
copy paste data

thanx

[Winon]

Hi HaroonSid,

There could be a variety of issues at play here, and I don't believe any of us on the Forum would like to enter a guessing solution.

Please could you attach a sample workbook.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Thank you.

[HaroonSid]

Hi, winnon
OK I change my requirement

No
In sheet2 range(A4:A) if duplicates find then delete the entire column only with duplicates

Thabx

[Winon]

Thank you for the feedback, HaroonSid,

Please try the Code Below. I think you meant delete duplicates within a Column, and not really the whole Column.

Please Login or Register  to view this content.

Regards.

[HaroonSid]

Sorry for my wrong question,
I want to delete the entire row with duplicate values

[Winon]

Then please try the Code below:

Please Login or Register  to view this content.

Regards.

[HaroonSid]

yes
now working perfectly

thanx alot for your hard work..

[Winon]

You are welcome HaroonSid, glad I could help.

Have a great day!

Regards.