+ Reply to Thread
Results 1 to 2 of 2

Inserting columns when cell xx = value xx

  1. #1
    Registered User
    Join Date
    02-08-2005
    Location
    Kent, UK
    MS-Off Ver
    2010
    Posts
    69

    Inserting columns when cell xx = value xx

    Our client system produces a 'past dates' report from them database. It lists the tasks along the top and the sites down the side with the dates at the data. As some tasks sometimes have no dates in the past the columns are not exported. Basically the report's width can vary (though only by a few columns).

    I'd like to insert any missing columns so that the report I issue is of a standard size and has all the tasks.

    The reason I want a standard report is that I want another macro that chops up the report into the various areas (some tasks are for one area to update, other tasks are for other areas to update).

    The code I have so far is:

    Please Login or Register  to view this content.

    But this doesn't appear to work. My line of thought is to check if a certain cell, e.g. AS2 has a certain task name and if not then insert a column.

    Is the code wrong? is there a better way to do this?

  2. #2
    Valued Forum Contributor
    Join Date
    06-17-2009
    Location
    Chennai,India
    MS-Off Ver
    Excel 2003,excel 2007
    Posts
    678

    Re: Inserting columns when cell xx = value xx

    try something like this


    Please Login or Register  to view this content.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1