+ Reply to Thread
Results 1 to 1 of 1

Creating a macro to delete columns based on a Range

  1. 08-15-2013, 02:14 AM #1
    10999989
    10999989 is offline
    Registered User
    Join Date
    08-08-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    10

    Creating a macro to delete columns based on a Range

    Hey all,

    As the title suggests i wish to delete column data based on a range. To complicate things this range is based on rank. the range may include values such as 13,14,15 etc. which I require Excel to lookup in the data headings stated in row 1 and delete them individually.

    Any Help would be much appreciated. To clarify I have attached an Sample file in which the objectives have been stated in sheet 2.
    Attached Files Attached Files
    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)

Similar Threads

  1. How to delete specific columns based on a named range of values from a worksheet
    By dronofrio in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-12-2012, 10:56 AM
  2. Macro to delete certain columns and delete rows based on time in another column
    By beepbeep27 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-12-2012, 11:47 AM
  3. Creating a macro that will delete row based on non matching cell to previous line
    By freidhofr in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-22-2012, 03:47 PM
  4. Help creating a macro that will delete row based on non matching cell to previous line
    By freidhofr in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-22-2012, 02:52 PM
  5. Macro to delete columns if they contain data - need help creating
    By heweaver in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 12-17-2008, 09:11 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1