+ Reply to Thread
Results 1 to 9 of 9

Automatic row removal

  1. #1
    Forum Contributor
    Join Date
    03-18-2010
    Location
    FL
    MS-Off Ver
    Excel 2016
    Posts
    145

    Automatic row removal

    Hi, I download an excel file from a vendor everyday and I need to automatically remove some rows that contains X data, for example rows containing abc, abc1 in column A. Please note the excel name vary. Any ideas? Thank you.
    Attached Files Attached Files
    Last edited by dandi10; 09-13-2019 at 08:38 AM.

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Lightbulb

    Hi !

    An idea : just use a filter then delete …

  3. #3
    Forum Contributor
    Join Date
    03-18-2010
    Location
    FL
    MS-Off Ver
    Excel 2016
    Posts
    145

    Re: Automatic row removal

    Thanks but I need something automatic, I don't want to filter everytime, also, I need to start typing for many filters, as for now I need to remove around 10 rows...

  4. #4
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Automatic row removal

    A sample before & after sample sheets based on actuals would be a useful guide rather than us speculating what you are on about.
    torachan.

  5. #5
    Forum Contributor
    Join Date
    03-18-2010
    Location
    FL
    MS-Off Ver
    Excel 2016
    Posts
    145

    Re: Automatic row removal

    Good idea, I have uploaded 2 files. The file "FIND" is what I need to look into to the another file, once found, remove these rows.

  6. #6
    Forum Contributor
    Join Date
    03-18-2010
    Location
    FL
    MS-Off Ver
    Excel 2016
    Posts
    145

    Re: Automatic row removal

    Any help please?

  7. #7
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,425

    Re: Automatic row removal

    Perhaps after so long a time without a response, you may settle for a formula based solution.
    Assuming that you want to keep the SKU's from Sheet1 that are not included in the list on Sheet2 (formerly the Find file), formulas are used to produce the table on Sheet3 as follows.
    1. A helper column (G) is added to sheet one and populated using: =ISNUMBER(MATCH(A2,Sheet2!A$2:A$10,0))
    Note that the helper column may be moved and/or hidden for aesthetic purposes.
    2. The formula that is used to produce the table on Sheet3 is: =IFERROR(INDEX(Sheet1!A$2:A$25,AGGREGATE(15,6,(ROW($A$2:$A$25)-ROW($A$1))/(Sheet1!$G$2:$G$25=FALSE),ROWS($A$1:$A1))),"")
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  8. #8
    Forum Contributor
    Join Date
    03-18-2010
    Location
    FL
    MS-Off Ver
    Excel 2016
    Posts
    145

    Re: Automatic row removal

    Thank you very much!

  9. #9
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,425

    Re: Automatic row removal

    You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.

+ 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. Replies: 3
    Last Post: 05-08-2017, 02:45 PM
  2. automatic removal of empty rows
    By mr.remizov in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-08-2017, 07:04 AM
  3. Automatic removal of duplicate rows
    By karimretina in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-05-2014, 09:10 AM
  4. Automatic Removal of X-Axis Categorical Values in a Bar Chart
    By megahuts in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-22-2010, 04:30 AM
  5. Replies: 2
    Last Post: 03-17-2010, 04:01 AM
  6. [SOLVED] Stacked Column Graph with automatic zero column removal
    By Niper in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-06-2010, 12:22 PM
  7. Excel 2007 : Automatic Sorting, Duplicate Removal
    By tyrsius in forum Excel General
    Replies: 4
    Last Post: 10-13-2009, 09:54 PM

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