• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Delete and Transfer Rows base on criteria

K

KIM Chanthan

Member
Hi,

Do you have any best way to delete and transfer rows base on criteria?
Please view attached file for more detail explanation on my problem.
Thanks for your kind help :) .

Chanthan
 

Attachments

  • Delete and Transfer Row base on criteria.xlsx
    10.3 KB · Views: 7
KIM Chanthan
hmm ...
1) If You move those yellow rows 5 & 7 form Sheet A to Sheet B ...
then those rows are not anymore in Sheet A - okay?
2) After that, You check from Sheet B, which row are not in Sheet A
... then You would like to delete those rows
... including those just moved rows ... hmm?
Or
would 'code' follow only Sheet B's gray areas wishes?
 
vletm said:
KIM Chanthan
hmm ...
1) If You move those yellow rows 5 & 7 form Sheet A to Sheet B ...
then those rows are not anymore in Sheet A - okay?
2) After that, You check from Sheet B, which row are not in Sheet A
... then You would like to delete those rows
... including those just moved rows ... hmm?
Or
would 'code' follow only Sheet B's gray areas wishes?
Click to expand...
Dear Vletm,

My issue is in Gray's areas wish!! It would be perfect if you can complete it.
Thanks for your time :D
 
vletm said:
KIM Chanthan
hmm?
I tested to click once and checked 'Sheet A'.
I clicked ten times ... 'Sheet A' looks to keep same.
What would need to happen or not?
Click to expand...
Dear Vletm,

I tested that file. When i click once, i see that CID "LC222" and "LC225" in sheet "A" have been moved to Sheet "B". At the same time, these 2 CID is not in sheet "A" anymore.

My point is i still want these 2 CIDs in sheet "A".

Thanks,
Chanthan
 
vletm said:
KIM Chanthan
Okay ...
If You have 2000 money in Your bank account.
Next You move 1000 Your money to my account.
How much money do You have in Your bank account?
Click to expand...
I am sorry!!! It might be my mistake on explaining!
I mean i want to copy or do sth else to get these 2 CID to sheet "B" without any change on sheet "A".
Sorry for any inconvenience.
 
You must log in or register to reply here.
Back
Top