Results 1 to 7 of 7

Deleting columns based on cell value

Threaded View

  1. #1
    Registered User
    Join Date
    01-09-2014
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    77

    Deleting columns based on cell value

    Hi all,

    I'm hoping one of you guys can help me out here. I have a spreadsheet (attached is a mock version) where I need to delete columns based on which cells are empty.

    On the 'helper' tab, cell A5 (with the help of other formulas) identifies which cells are blank on the 'fullschedule' tab. I then had to write each macro to suit each combination of cells that were empty, but the number of combinations was getting out of control.

    So for example, if A5 on the 'Helper' tab identifies that cells 'CILNPX' on the 'Fullschedule' tab are empty (which it has in the attached), how can I get columns CILNPX on the 'FullSchedule' tab to delete when the macro runs?

    Thank you in advance for your time, I've looked around and can't find much to help me on this.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Deleting Columns based on Cell Values VBA
    By Matty5894 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-20-2014, 08:58 AM
  2. [SOLVED] Deleting multiple columns based on columns' first row value
    By {=OR(value=array)} in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-14-2014, 04:00 PM
  3. [SOLVED] Deleting rows based on a certain columns 'prefixes'?
    By Mgassma in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-02-2013, 03:40 PM
  4. deleting rows based on value in columns.
    By barksmith in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 04-28-2009, 12:21 PM
  5. [SOLVED] Deleting Columns Based upon Heading
    By Jessica in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-03-2005, 07:10 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1