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

Unable to write a VBA code for copying with a condtition

I have a excel worksheets with two sheets . Data and Report sheet. I am new with vba coding. I have written a code to copying data from one sheet to another. But it copies all the data whereas I want that if the condition col. E ( Printed) met. Then only it updates the report sheet with rows and deletes the copied rows from the data sheet.
 

Attachments

  • Printing Report.xlsm
    52.9 KB · Views: 3
Use a filter - or an advanced filter - then it's easy to copy the rows to the destination then to delete them,​
activate the Macro Recorder and try, that's easy !​
 
Back
Top