+ Reply to Thread
Results 1 to 3 of 3

Macro To Clear All Content in a Column Except a List

  1. 01-17-2011, 10:29 AM #1
    princesakthi
    princesakthi is offline
    Registered User
    Join Date
    12-21-2007
    Posts
    2

    Talking Macro To Clear All Content in a Column Except a List

    Hi,

    I Need a Macro To Clear All Content (Not Delete Rows) in a Column Except a List.

    List Data
    America
    Africa
    India
    Japan

    Work Sheet Data
    India
    America
    England
    Africa
    China
    Japan


    As per List England and China Not Exist. Hence This Cell Should Be Cleared. It Should come like this
    India
    America

    Africa

    Japan

    Thanks in Advance.
    Last edited by princesakthi; 01-17-2011 at 10:39 AM.
    Reply With QuoteRegister To Reply
  2. 01-17-2011, 10:35 AM #2
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Macro To Clear All Content in a Column Except a List

    Can you give more details. Maybe attach an example
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example
    Reply With QuoteRegister To Reply
  3. 01-17-2011, 10:41 AM #3
    princesakthi
    princesakthi is offline
    Registered User
    Join Date
    12-21-2007
    Posts
    2

    Re: Macro To Clear All Content in a Column Except a List

    Sir,
    Now I Give Example.
    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)

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1