+ Reply to Thread
Results 1 to 3 of 3

How to delete a worksheet if it doesn't exist in a list

  1. #1
    Registered User
    Join Date
    01-21-2013
    Location
    Glasgow, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    25

    How to delete a worksheet if it doesn't exist in a list

    Hi

    I have a spreadsheet that creates a seperate worksheet for every item in a list, I want to then be able to change this list of data so that if I delete a line of data out of the list I could run a seperate macro that looks at the existing worksheets and deletes any that is not on that list.

    Is this possible?

    Regards

    R

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: How to delete a worksheet if it doesn't exist in a list

    Hi.

    Its possible. Post a sample file.
    Click *, if my suggestion helps you. Have a good day!!

  3. #3
    Registered User
    Join Date
    01-21-2013
    Location
    Glasgow, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: How to delete a worksheet if it doesn't exist in a list

    Due to the Data I am trying to analyse it is impossible for me to post this to a public forum, if you have any ideas on how this could be done if you could post an example of code I will happily interpret it... I would need to create a mock up outside of the work environment however...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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