Results 1 to 2 of 2

How to delete entire column if it is Empty

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-28-2011
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    115

    How to delete entire column if it is Empty

    I have columns
    Row 1 is heading..


    IF Column C doesn't have data in entire column then delete C D E F
    IF Column D doesn't have data in entire column then delete D E F
    IF Column E doesn't have data in entire column then delete E F
    IF Column F doesn't have data in entire column then delete F


    Same way for heading NN's

    IF Column G doesn't have data in entire column then delete G H I J K L M N
    IF Column H doesn't have data in entire column then delete H I J K L M N
    IF Column I doesn't have data in entire column then delete I J K L M N
    IF Column J doesn't have data in entire column then delete J K L M N
    IF Column K doesn't have data in entire column then delete K L M N
    IF Column L doesn't have data in entire column then delete L M N
    IF Column M doesn't have data in entire column then delete M N
    IF Column N doesn't have data in entire column then delete N

    A B C D E F G H I J K L M N O P Q R
    TITLE1 TITLE2 TT1 TT2 TT3 TT4 NN1 NN2 NN3 NN4 NN5 NN6 NN7 NN8 CMT K2 K3
    BLAH BLAH


    Thanks
    Last edited by zit1343; 02-21-2013 at 11:11 AM.

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