Results 1 to 6 of 6

Bulk deleting lines/rows of data.

Threaded View

  1. #1
    Registered User
    Join Date
    05-01-2018
    Location
    Bury St Edmunds, Suffolk
    MS-Off Ver
    2016
    Posts
    3

    Bulk deleting lines/rows of data.

    Hi,

    I have spreadsheet A which has a list of current product lines.

    I have spreadsheet B which has a list of current product lines as above but also has items which have been discontinued/deleted and need to be removed from spreadsheet B as they do not appear in spreadsheet A.

    I have identified the products which should not be in spreadsheet B see attached spreadsheet titled "Items to delete"

    Is there a way I can bulk delete these identified product rows from spreadsheet B. (sample of spreadsheet B attached)

    Thanks

    Rich
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Deleting Repeated Lines of Data
    By ISUCyclones in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-10-2016, 12:22 PM
  2. Replies: 1
    Last Post: 10-09-2015, 09:19 AM
  3. Deleting Repeating Lines of Data
    By ISUCyclones in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-11-2014, 12:26 PM
  4. Deleting Rows in Bulk that have certain text
    By dawsonsoo in forum Excel General
    Replies: 3
    Last Post: 12-06-2013, 06:02 PM
  5. [SOLVED] Macro help with combining data across 2 rows (and deleting non-required rows)
    By InnesMcc in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 05-20-2013, 05:21 AM
  6. Bulk removing rows by data
    By rugbyjack2005 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-27-2012, 07:48 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