• 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.

Consolidating the file

Brunda

Member
Hello All,

I hope you are doing good.

Required help in the sample file given below in the automated form

File containing comments like sideline, doubt, non-workable kind of keywords rows to be move to different sheet and gets deleted from the file sheet.

Kindly help us with this

Thanks,
Brunda
 

Attachments

  • Book3.xlsx
    19.2 KB · Views: 4
Specifically, which words should trigger removal of the row. List all so that the solution will work for all your cases. Alternatively, tell us which words should be kept as criteria. We cannot guess as to what you think is an appropriate comment.
 
Specifically, which words should trigger removal of the row. List all so that the solution will work for all your cases. Alternatively, tell us which words should be kept as criteria. We cannot guess as to what you think is an appropriate comment.

These are the majorly used in comment and doubt columns.
ASIN is yanked
Image title mismatch
No Image
Sidelined-other
Non-Workable
Yanked
Invalid
Doubtful
 
Which are these? Criteria to remove or criteria to keep.

Do you really need a macro or can you just filter for the items you wish to keep.
In the first row--Data--> Filter
Click on the drop down and unclick those you don't wish to see.

Copy and paste to a new sheet if necessary.

If you really need VBA, then answer my question above.
 
Which are these? Criteria to remove or criteria to keep.

Do you really need a macro or can you just filter for the items you wish to keep.
In the first row--Data--> Filter
Click on the drop down and unclick those you don't wish to see.

Copy and paste to a new sheet if necessary.

If you really need VBA, then answer my question above.
This is criteria to be removed and paste in different sheet.
Yes we do filter out manually but der would different kinds and more number of comments in the comment and doubt section and we handle large number of data manually filtering out is time consuming
 
Back
Top