+ Reply to Thread
Results 1 to 2 of 2

delete multiple sheets with a condition

  1. 07-24-2015, 12:30 AM #1
    annux08
    annux08 is offline
    Registered User
    Join Date
    07-01-2015
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    42

    delete multiple sheets with a condition

    Hi,

    I have a workbook containing multiple sheets & I want to delete all the sheets whose name is ending with 2015. The condition here is there are some sheets name are ###2015### which I do not want to delete.


    Following are the sheet names:
    Jan_2015
    Feb_2015
    Mar_2015
    HR_2015
    ACS_2015
    Jan_201516 (should not be deleted)
    Feb_201516 (should not be deleted)

    I have attached a sample file. Please help.

    Anna
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-24-2015, 12:42 AM #2
    NeedForExcel
    NeedForExcel is offline
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: delete multiple sheets with a condition

    Here!

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Cheers!
    Deep Dave
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. select distinct value from multiple sheets where a condition is true
    By groexcel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-15-2015, 07:23 AM
  2. Macro for combining multiple sheets to one sheet with a condition
    By ashaanna88 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-19-2013, 05:18 AM
  3. [SOLVED] Delete row in multiple sheets
    By sarinky in forum Excel General
    Replies: 2
    Last Post: 10-22-2012, 11:05 PM
  4. sum multiple sheets based on condition
    By Mile029 in forum Excel General
    Replies: 2
    Last Post: 05-25-2011, 04:59 PM
  5. Search and Delete Across Multiple Sheets According to Values in Sheets
    By Tyler_Durden in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-12-2009, 04:40 PM
  6. by selecting filter condition in one sheet filtering on multiple sheets automatically
    By sethumurugan in forum Excel General
    Replies: 1
    Last Post: 04-15-2009, 09:44 AM
  7. Delete Multiple sheets
    By moglione1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-04-2006, 10:25 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1