Find Missing Dates

[jackt05]

Hi everybody,

I have data as follows:

Date KMS Roster No CAB No.
3 30 120404 3620
3 28 69736 3620
8 70 121736 3620
8 34 121870 3620
9 34 71258 3620
9 72 71369 3620
24 44 37069 9794
29 70 76528 9794
29 66 76418 9794
1 66 68801 8035
1 66 119477 8035
3 34 101495 8035
3 66 69563 8035
3 66 120267 8035
4 66 69943 8035

Now here cab 3620 is absent on 4 5 6 & 7 & cab 9794 is absent on 25 26 27 28 & cab 8035 is absent on 2nd . a cab works for full month I want to fill the dates and cab no automatically like it should enter a row with the missing date and the particular cab no.

Thanks

[teylyn]

Hi,

it's hard to tell which information above is what. Please post an Excel workbook with your data layed out and then specify what you would like to appear where and what the logic behind it should be.

[jackt05]

Find Attachment

Now here cab 3620 is absent on dates 4 5 6 & 7 & cab 9794 is absent on dates 25 26 27 28 & cab 8035 is absent on dates 2nd .
A cab works for full month I want to fill the dates and cab no automatically .

Thanks Mr. Teylyn