+ Reply to Thread
Results 1 to 3 of 3

Delete a sheet when data in a column with the same name is deleted.

  1. #1
    Forum Contributor
    Join Date
    11-25-2018
    Location
    Philippines
    MS-Off Ver
    Ms Office 365
    Posts
    217

    Delete a sheet when data in a column with the same name is deleted.

    The thing is I have unique control numbers in column B.
    Those unique numbers have a corresponding sheet name identical to the control number.
    Is there a way to auto delete the sheets when I delete a control number in column B?
    Last edited by archvanarl; 02-24-2022 at 03:23 AM.

  2. #2
    Valued Forum Contributor PaulSP8's Avatar
    Join Date
    11-21-2017
    Location
    Chorley, England
    MS-Off Ver
    2013 & 2021
    Posts
    437

    Re: Delete a sheet when data in a column with the same name is deleted.

    Put this in the code for the Worksheet that holds the Control Numbers;

    Please Login or Register  to view this content.
    HTH

  3. #3
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: Delete a sheet when data in a column with the same name is deleted.

    Please Login or Register  to view this content.
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!

+ 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. Delete row in linked Sheet if Master Sheet row is deleted
    By SANJISH in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-05-2020, 09:47 AM
  2. Replies: 2
    Last Post: 12-12-2018, 05:02 PM
  3. [SOLVED] Delete the duplicates and add deleted data's value
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-25-2014, 01:08 AM
  4. [SOLVED] Delete paste-linked row from another sheet after that sheet has been deleted
    By poptart141 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-08-2013, 12:09 PM
  5. [SOLVED] referenced sheet deleted which should not delete the reference formula.
    By jbshew in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-23-2012, 03:19 PM
  6. [SOLVED] if a row deleted in sheet 1 delete in sheet 2
    By lagarepro in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-19-2012, 03:32 PM
  7. [SOLVED] how to ensure that the chart will be deleted after i delete data
    By Sagar Bhandari in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-21-2005, 09:05 AM

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