+ Reply to Thread
Results 1 to 4 of 4

Need to Delete Multiple rows if numbers dont match on another sheet

  1. #1
    Forum Contributor
    Join Date
    10-26-2012
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    133

    Need to Delete Multiple rows if numbers dont match on another sheet

    I need to clear contents of multiple rows of data on the Wood Total sheet if the number in column A of the Wood Total sheet does not match the same number in column A of the Cabinet Total sheet.
    There will be about a thousand rows of data on the Wood Total sheet. When the rows are cleared I would like the data below the cleared row to move up so that there are no rows without data. Thanks in advance.

    I really dont want to delete the data because there is other data to the right. Thanks

    Wood Parts.PNGCabinet Total.PNG

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: Need to Delete Multiple rows if numbers dont match on another sheet

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Contributor
    Join Date
    10-26-2012
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    133

    Re: Need to Delete Multiple rows if numbers dont match on another sheet

    I have attached a sample workbook. Sheet Cabinet Total (Before) shows Cab# 2 in column A. When I delete row #4 (Cab# 2) on the Cabinet Total Sheet I want the Wood Total sheet to automatically clear contents all of the rows with Cab# 2 in Column A and move the existing data up so there are no blank rows as shown on Sheet Wood Total (After). I dont want to delete the rows on the Wood Total sheet because I have other data to the right. I hope this is clear. Thanks


    Sample Workbook Before and After.xlsx

  4. #4
    Forum Contributor
    Join Date
    10-26-2012
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    133

    Re: Need to Delete Multiple rows if numbers dont match on another sheet

    Admin, is it possible to move this thread to Programing/VBA/Macros
    Not getting much help here
    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] trying to delete columns in a worksheet that dont match header values
    By Rob69mfj in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-21-2014, 03:46 PM
  2. delete rows where the numbers dont match
    By steve111 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-04-2014, 03:17 PM
  3. How to automatically delete rows which dont match criteria
    By Endorphin in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-11-2006, 10:51 AM
  4. Delete Rows that dont match criteria in VB
    By mad_lock in forum Excel General
    Replies: 0
    Last Post: 01-26-2005, 08:12 AM
  5. Delete Rows that dont match criteria in VB
    By mad_lock in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-26-2005, 06:41 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1