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

Need a Mecro to Fix my file

N

nadjalil

Member
Dear Frnds
i need your help to fix my attached file, and i need a macro to delete all the rows based on D column and the criteria will if cell is empty, if it has "Date :" or "Qatar Lu" or "Dimensio" or "--------" or "Period" or "Ledger A". in fact i have a macro for this but it's not working. length of data range should be consider upto 500,000 rows or more as i need to do this exercise on more than that many row, it's a text file generated by our system which in need to fix to make it understandable.
thanks for your help.
Kind Regards
 

Attachments

  • Cutting of Print finalized Transaction by Dim Report - Chandoo.xlsm
    158.5 KB · Views: 4
Hi Nadjalil,

Please look at attached file, there is a button on sheet2, to run the macro.

Sheet2 also has the Criteria.

The Macro does the following:
Inserts a row on Sheet1
Adds Headers to the Sheets
Filters per the criteria.

You can then Select the results and Delete the Rows manually

Cheers

kanti
 

Attachments

  • Cutting of Print finalized Transaction by Dim Report - Chandoo_v1.xlsm
    164.8 KB · Views: 4
You must log in or register to reply here.
Back
Top