Results 1 to 2 of 2

Thread: Can some one please help me with V.B.A code to remove the unwanted data in the sheet.

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Seeker boddulus's Avatar
    Join Date
    Sep 2014
    Posts
    6
    Articles
    0
    Excel Version
    Excel 2010

    Question Can some one please help me with V.B.A code to remove the unwanted data in the sheet.

    Hi folks Good morning, Good afternoon or Good evening to all of you......

    I am new to VBA coding, i have been assigned a project where i have to clean up the data and do valuation on it. but the data size is every huge like i have around 2000 rows in each sheet i have 15 sheet with similar pattern of data but with slight changes in each sheet.
    1) I want all the blank rows and all the rows with unwanted data (like R1 to R6) like security,secu,-----,uds, all of them should get filtered and get deleted,but "before deleting also excel should ask whether it is ok to delete this data or not and when i click on ok it should get deleted"
    2) I want all the rows with value equal to 0.00001 in column 7 and column 8 should get filtered out and get deleted,but "before deleting also excel should ask whether it is ok to delete this data or not and when i click on ok it should get deleted"
    3) I want all the rows with values which starts with "UBS" in column 4 should get filtered out and get deleted,but "before deleting also excel should ask whether it is ok to delete this data or not and when i click on ok it should get deleted".
    i want this all this happen in sequence and apart from above conditions rows i don't want to miss even one row please.
    Note : there is a slightest difference in sheet 1 and sheet 2 "UBS" is not there in sheet 2 ,please frame a code for all sheets in such a conditions that the macro doesn't get struck if one of the above conditions are not there in any of the sheet.
    I have attached the workbook with sample sheets (Sheet 1 and sheet 2) . the data is huge(around 2000 rows) and sheets are around 15 with 1 or 2 or all above conditions in the sheet.
    Thanks for your time and effort. your work will be much appreciated......... thanks in advance....
    Please share your results after testing on my sample sheets.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •