Insert rows for missing dates

Hello,

I have a list of tasks to do spanning 200+ days. This data is imported into Excel from MS Project so will only contain dates with some activity against them (these are the start dates of the activities so will only be represented by one day). I would like to know how I can force Excel to insert rows for missing dates in a large spreadsheet so I can easily identify any days with no tasks assigned to them.

Below is an example of what I CURRENTLY have;

COLUMN A ** COLUMN B ** COLUMN C
03/08/09 ** Mon ** Meet Customer
03/08/09 ** Mon ** Contact suppliers
04/08/09 ** Tue ** Obtain licence agreements
06/08/09 ** Thur ** Contact HR anbout new starters
10/08/09 ** Mon ** Meet new starters
10/08/09 ** Mon ** Arrange directors meeting
10/08/09 ** Mon ** Book offsite function room
14/08/09 ** Fri ** Prepare budget reports


Below is what I WOULD LIKE to have;

COLUMN A ** COLUMN B ** COLUMN C
03/08/09 ** Mon ** Meet Customer
03/08/09 ** Mon ** Contact suppliers
04/08/09 ** Tue ** Obtain licence agreements
05/08/09 ** Wed **
06/08/09 ** Thur ** Contact HR anbout new starters
07/08/09 ** Fri **
08/08/09 ** Sat **
09/08/09 ** Sun **
10/08/09 ** Mon ** Meet new starters
10/08/09 ** Mon ** Arrange directors meeting
10/08/09 ** Mon ** Book offsite function room
11/08/09 ** Tue **
12/08/09 ** Wed **
13/08/09 ** Thur **
14/08/09 ** Fri ** Prepare budget reports
15/08/09 ** Sat **
16/08/09 ** Sun **


PLEASE NOTE: the astrix are only to separate the columns on this tread and are not present in the spreadsheet.

I do not need any data inserted into column C,D,E,F etc but would like columns A and B populated (column B is a "nice have" - I can live without this being populated by the macro)

Does anyone know of a function or suitable macro code that will do this?

Your help will be most appreciated.

Many thanks.

Sorry - new to this and still finding my way around!

Here is what I came up with:

Please Login or Register  to view this content.

Change "For i = 2..." to "For i = 3..." to account for the header row.
The columns are assigned as the second argument in cell(). So it goes cell(row,column).
To change the column from 1 to 4 you'd go: cells(row,4) instead of cells(row,1). Make sense?