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:
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?
Bookmarks