+ Reply to Thread
Results 1 to 1 of 1

Delete row based on cell value matched from list (found in other sheet or workbook)

  1. #1
    Registered User
    Join Date
    05-05-2021
    Location
    Dallas
    MS-Off Ver
    2016 home/2013 work
    Posts
    1

    Delete row based on cell value matched from list (found in other sheet or workbook)

    Good morning everyone, first post here.

    I have a weekly report with details on inventory and need to remove the rows containing items listed on StopSale. Ideally this would not disrupt the rest of the list so I can perform subtotals etc.

    I would like to create a macro to accomplish this.

    Stk# are listed in column B of Details sheet and the references are listed on StopSale sheet.

    Can this be done? Could I have the StopSale saved as a separate workbook and referenced in the macro?
    Attached Files Attached Files

+ 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] Delete to last row based on found cell value using find function
    By terriertrip in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-01-2019, 04:40 PM
  2. Replies: 9
    Last Post: 01-20-2017, 10:31 PM
  3. Replies: 4
    Last Post: 01-22-2014, 12:37 AM
  4. Change cell colour, based on matched cells in sheet 2
    By Bobbo Jones in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-14-2013, 02:27 AM
  5. Hyperlinking to Matched Cell in Seperate Sheet in Workbook
    By SAthena7 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-15-2012, 05:18 PM
  6. [SOLVED] Change cell contents if found in a list on another sheet
    By fastcar in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-05-2012, 08:29 PM
  7. Delete Row based on record found in cell
    By capnhud in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-20-2012, 09:04 AM

Tags for this Thread

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